I was wondering if there was a way to grant just these to permissions to a role. I found the db_ddladmin role out there which allows the grantee to perform these plus many more. I would like to have a couple people to be able to create tables, but not stored procedures.<br>Thanks in advanced.
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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Specific Grant on CREATE TABLE and CREATE PROCEDURE command
- Thread starter tkatlas
- Start date
Similar threads
- Locked
- Question
- Locked
- Question