What permissions does db_owner not have? (In SQL Server 2008) [closed]

Posted on

Question :

Can you list the permissions that db_owner cannot do.

Answer :

Permissions of Fixed Database Roles: db_owner: has CONTROL permission with GRANT option in the database and VIEW ANY DATABASE permission in the server. To understand what that entails, read all of the following:

From books online, members of the db_owner fixed database role can: –

Members of the db_owner fixed database role can perform all
configuration and maintenance activities on the database, and can also
drop the database.

Those permissions are specific to an individual database. What that login doesn’t have, is permissions in other databases (unless granted separately) or server level permissions.

Server level permissions would be granted by adding the login to a server level role or by granting specific server level permissions.

The 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 Ref : – https://msdn.microsoft.com/en-us/library/ms189121.aspx

Any members of the db_owner fixed server role can do anything they want within that database (include drop the database). They can’t do anything outside the database without additional rights.

Leave a Reply

Your email address will not be published. Required fields are marked *