How to give create Stored permissions on a DB?

[SteveMe]

Please advise? Thanks

 

[mrdenny]

Using the GRANT command.

Use Database
go
grant create procedure to UserName
go

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[SteveMe]

I did that even gave them the dbo role and no luck

 

[mrdenny]

If you are a member of the db_owner role then you can create procedures, there is no way to revoke rights from a member of the db_owner role. Make sure that the user is in the correct database.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com