Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jshurak
Starting Member
44 Posts |
 Posted - 2006-11-17 : 11:47:32
|
| What roles or permissions does a user need to create stored procedures?Jshurak - The International Businessman of Mystery |
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2006-11-17 : 11:51:24
|
| In Books Online for the CREATE PROCEDURE statement, I found this, fancy that!PermissionsCREATE PROCEDURE permissions default to members of the sysadmin fixed server role, and the db_owner and db_ddladmin fixed database roles. Members of the sysadmin fixed server role and the db_owner fixed database role can transfer CREATE PROCEDURE permissions to other users. Permission to execute a stored procedure is given to the procedure owner, who can then set execution permission for other database users. |
 |
|
|
jshurak
Starting Member
44 Posts |
Posted - 2006-11-17 : 14:20:23
|
| Thanks! Do you have a link for that?Jshurak - The International Businessman of Mystery |
|
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2006-11-17 : 16:38:00
|
| Open Books Online, go to the Index, type CREATE PROCEDUREOr I guess I can go and find it for you on the MS web site2000 - http://msdn2.microsoft.com/en-US/library/aa258259(SQL.80).aspx2005 - http://msdn2.microsoft.com/en-us/library/ms187926.aspx |
|
|
|
|
|
|
SQL Server roles