Running extended stored procedure without perms on master db

[douggy]

I have a VB app that runs the sp_execute SP for a table update.

Is there any way of letting the user run the sp_execute without gicing him master permissions.

Any help would be great.

Thanks
Mark

 

[Corran007]

granting it public access to master then execute permissions for sp_execute is the only way i know. We ususally create a specific user for a application and handle security ourselves for this very reason

 

[LogicalmanUS]

douggy,

I concur totally with Corran007, create an application-specific login, and grant it only permissions as required.

Logicalman