Granting dbo System Role

The dbo system role owns many system stored procedures and views.

Prerequisites

Requires the MANAGE ROLES system privilege.

Task

The dbo system role is a member of the SYS system role. The PUBLIC system role is a member of the dbo system role. The dbo system role can be granted to other roles with no administrative rights only.

The WITH ADMIN OPTION or WITH ADMIN ONLY OPTION clauses are not valid when granting the dbo system role.

To grant the dbo system role, execute:

GRANT ROLE dbo TO grantee [,...]