Granting EXECUTE permissions to all stored procedures
From: DBA72 (anonymous_at_discussions.microsoft.com)
Date: 04/30/04
- Next message: G: "Securing Merge Replication"
- Previous message: TomO: "Re: Data Encryption"
- Next in thread: Hari: "Re: Granting EXECUTE permissions to all stored procedures"
- Reply: Hari: "Re: Granting EXECUTE permissions to all stored procedures"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Fri, 30 Apr 2004 01:31:03 -0700
I want to allow my user to have exec permissions on all stored procs in the database. Is there a quick way to do this? Right now, the only way I know how to do this is to go into the permissions for the user and check the EXEC checkbox for each individual stored proc...
- Next message: G: "Securing Merge Replication"
- Previous message: TomO: "Re: Data Encryption"
- Next in thread: Hari: "Re: Granting EXECUTE permissions to all stored procedures"
- Reply: Hari: "Re: Granting EXECUTE permissions to all stored procedures"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]