Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Granting permissions to SP's --- from an SQLEXEC() --- V
Message
General information
Forum:
Microsoft SQL Server
Category:
Stored procedures, Triggers, UDFs
Miscellaneous
Thread ID:
00445148
Message ID:
00445274
Views:
15
If you use sp_helptext to view the source for your stored procedure, I'll bet you see the GRANT statement at the bottom. The definition of a stored procedure ends at the end of the batch. Try sending the GRANT statement through on another call:

SQLEXEC(h, "CREATE PROCEDURE...")
SQLEXEC(h, "GRANT EXECUTE...")

-Mike
Michael Levy
MCSD, MCDBA
ma_levy@hotmail.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform