scripting permission on stored Procedures on SQL 2000  
Author Message
CarlOKC





PostPosted: Mon Dec 08 02:50:25 CST 2003 Top

SQL Server Developer >> scripting permission on stored Procedures on SQL 2000

To create stored procedures, I use the SQL create
statement.
Then I add the access permissions manually using the
management console.
This manual step I would like to include in the create
statement. How can I do this?
Thank you very much for hints.

SQL Server217  
 
 
Tibor





PostPosted: Mon Dec 08 02:50:25 CST 2003 Top

SQL Server Developer >> scripting permission on stored Procedures on SQL 2000 Use the GRANT, DENY and REVOKE command. Also, use sp_addrolemember if you
want to assign roles to users.

--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver




> To create stored procedures, I use the SQL create
> statement.
> Then I add the access permissions manually using the
> management console.
> This manual step I would like to include in the create
> statement. How can I do this?
> Thank you very much for hints.