Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Granting permissions to SP's --- from an SQLEXEC() --- V
Message
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Stored procedures, Triggers, UDFs
Divers
Thread ID:
00445148
Message ID:
00445274
Vues:
20
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform