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)
|
Backup my known things and restoring it into DBA Learners.......
Tuesday, May 29, 2012
Difference between database roles and server roles
Subscribe to:
Post Comments (Atom)
MYSQL:::Seamless Data Archiving: Exporting, Importing, and Pruning MySQL Tables
Seamless Data Archiving: Exporting, Importing, and Pruning MySQL Tables Introduction: In the dynamic landscape of database management...
-
Post scripts to implement after successful SQl Server installation in a new server: 1. Listing the advanced configuration options and ...
-
An error occurred while starting mirroring. Alter failed for Database 'XXXXX'. (Microsoft.SqlServer.Smo) The remote copy of dat...
-
Scenario: I am looking to remove the characters value ‘SQL Server’ from the ‘SQL Server 9.00.4060.00’ in one column on the tablix...
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