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...
-
When i trying to load data from MS access (MDB) to SQL ,i am getting the below error. Error: 0xC0209303 at Package, Connection mana...
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