|
S.No
|
Server Roles
|
Database Roles
|
|
1
|
It is defined at the server level.
|
It is defined at the database level.
|
|
2
|
It exists outside of user databases.
|
It exists in each database.
|
|
3
|
There are fixed server roles only.
|
User defined database roles available.
|
|
4
|
Bulkadmin,dbcreator,diskadmin,
processadmin,securityadmin,
serveradmin,setupadmin
and sysadmin(8)
|
Db_accesadmin,db_backupoperator,
db_datareader,db_datawriter,
db_ddladmin,db_denydatareader,
db_denydatawriter,db_owner and db_securityadmin(9)
|
Tuesday, May 29, 2012
Difference between database roles and server roles
Subscribe to:
Post Comments (Atom)
-
When i trying to load data from MS access (MDB) to SQL ,i am getting the below error. Error: 0xC0209303 at Package, Connection mana...
-
Seamless Data Archiving: Exporting, Importing, and Pruning MySQL Tables Introduction: In the dynamic landscape of database management...
-
An error occurred while starting mirroring. Alter failed for Database 'XXXXX'. (Microsoft.SqlServer.Smo) The remote copy of dat...
Great list, thanks!
ReplyDeleteAlso a nice explanation right here:
Database Roles
Thanks Buddy....
ReplyDeleteGreat differentiation and with listing of either one. With Sql server 2012 onwards, there is possibility to user defined server role as well.
ReplyDeleteIt helps me lot ..
ReplyDelete