set up Role - SQL Server Forums

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 Administration

set up Role

Author

Topic

arvind_ramugade
Starting Member

30 Posts

Posted - 2012-04-04 : 02:12:12

Hi,
Is there any way to set up a new Role or permissions for SQL Server or all the below roles are fixed ?
db_accessadmin
db_backupoperator
db_datareader
db_datawriter
db_ddladmin
db_denydatareader
db_denydatawriter
db_owner
db_securityadmin

Regards
Arvind.

ramugade

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2012-04-04 : 12:43:02

Sure, you can use Create Role

X002548
Not Just a Number

15586 Posts

Posted - 2012-04-04 : 13:20:32

ummm..do you mean sa?

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Want to help yourself?

http://msdn.microsoft.com/en-us/library/ms130214.aspx

http://weblogs.sqlteam.com/brettk/

http://brettkaiser.blogspot.com/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources