Granting the dbo System Role

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

Prerequisites

MANAGE ROLES system privilege.

Task

By default, the dbo system role is a member of the SYS system role and SYS_AUTH_RESOURCE_ROLE compatibility role with no administrative rights. It is also a member of the SYS_AUTH_DBA_ROLE compatibility role with full administrative rights.

You can grant the dbo system role to other roles only with no administrative rights (WITH NO ADMIN OPTION clause). The WITH ADMIN OPTION and WITH ADMIN ONLY OPTION clauses are invalid for the dbo system role.

You can grant system privileges and roles to, and revoke them from, the dbo system role, including the default roles.

To grant the dbo system role, execute:

GRANT ROLE dbo TO grantee [,...]