I can't seem to find any documentation on whether or not you can include
variables or in-line select statements with the Grant Execute function. I
am trying to create a Stored Proc to grant execute rights on all user
created stored procedures to a specific user. Seems straight-forward, but
the procedure should receive this user from a VB app. The parameter would
be passed to the Stored Proc by the app in a call to the Stored Proc. Is
there a way to create the Stored Proc with the Grant Execute AND a variable
My issue seems to be the Grant Execute function. I cannot get the procedure
to accept a variable in place of the user_name or an in-line Select
Here's the SP that granting the execute rights:
Grant Execute On (Select [name] From sysobjects Where [xtype]='P')
Where [Processors] is a database role.
The other SP I'm working on is:
from the VB app.
Any help is greatly appreciated. Willing to read up if you'll direct me to
the right place!
Associated Systems, Inc.