I have to add a new database role to one of my SQL 2005 databases so I can grant execute permissions for it to some applicable sp's. Is this something my company's SQL database administrator has to do or can it be done locally, by me, for example, thru a wizard or by executing some script. Thanks for your help.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Add Database Role in SQL
- Thread starter batteam
- Start date
In order to create a database role, you need to be a db_securityadmin for the database that you are creating the role in.
To determine if your login has the appropriate permissions, you can run this:
-George
Microsoft SQL Server MVP
My Blogs
SQLCop
twitter
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom
To determine if your login has the appropriate permissions, you can run this:
Code:
Select IS_MEMBER('db_securityadmin')-George
Microsoft SQL Server MVP
My Blogs
SQLCop
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom
- Status
Similar threads
- Locked
- Question
- Question