Thursday, February 27, 2014

impact of assigning dbowner privelege to a user/login


Hello,


If I assign dbowner privelege to a login/user would that user be able to access all the objects in that specific database or the objects owned by the user only.


Best regards,


Vishal



Hi Vishal,


Members of the db_owner fixed database role can perform all configuration and maintenance activities on the database, and can also drop the database. For more information regarding Server and database roles in SQL Server, please see:

http://ift.tt/Nai3S8


Regards,




Elvis Long

TechNet Community Support



No comments:

Post a Comment