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 |
|
bogey
Posting Yak Master
166 Posts |
 Posted - 2008-06-05 : 16:58:38
|
| Is it possible to use sql server managment studio to grant the create procedure to a user on their own schema? |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-06-05 : 21:38:01
|
| You can do like this:Grant create procedure to [username] |
 |
|
|
bogey
Posting Yak Master
166 Posts |
Posted - 2008-06-06 : 08:14:11
|
quote:
Originally posted by sodeep
You can do like this:Grant create procedure to [username]
I did that and upon furter poking around found out how.Right Click on you database, under select page in the left column choose Permissions. From there your able to grant the create procedure. |
|
|
|
|
|
|
Grant Create Procedure Using SSMS