.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
 
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
SP
satyapriyanayak
Subhransu Sekhar Jena
abhays
DotnetUser

Home >> Articles >> DataBase >> Post New Resource Bookmark and Share   

 Subscribe to Articles

What are the database roles in sql server?

Posted By:Ramesh P       Posted Date: October 30, 2010    Points: 50    Category: DataBase    URL: http://www.dotnetspark.com  

It helps to learn database roles in sql server.
 


Database Roles:

db_owner:can manage any access in the database

db_accessadmin:can manage add\remove the user

db_securityadmin:can manage roles and members of sqlserver database roles,and statement and object level permission

db_datareader:user can able to see the all the data in user table.

db_datawriter:user can able to change,add and delete the data in user tables.

db_ddladmin:user can able to alter,change,drop objects in the database(ddlcommand)

db_backoperators:can take the backup of the database

db_denydatareader:denies permission to select the data in the database

db_denydatawriter:denies permission to change the data in the database.
 Subscribe to Articles

     

Further Readings:

Responses

No response found. Be the first to respond this post

Post Comment

You must Sign In To post reply
Find More Articles on C#, ASP.Net, Vb.Net, SQL Server and more Here

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend