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.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Permissions to create a Stored Procedure

Author  Topic 

jggtz
Starting Member

32 Posts

Posted - 2008-04-30 : 23:42:35
A simple one (not for me)

MS SQL Server 2005

Which permissions do I need to have (as a User) to create a Stored Procedure
Which other entity's properties do I need to change in order to create a Stored Procedure

Thanks

sunsanvin
Master Smack Fu Yak Hacker

1274 Posts

Posted - 2008-05-01 : 02:07:21
you need DBowner permissions as well as read and write

Vinod
Even you learn 1%, Learn it with 100% confidence.
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-05-03 : 21:01:35
Not really, db_ddladmin can create db objects.
Go to Top of Page
   

- Advertisement -