Granting dbo System Role

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

Prerequisites

Requires the MANAGE ROLES system privilege.

Task

By default, the dbo system role is granted the MANAGE PROFILING system privilege with administrative rights only and the PUBLIC system role with no administrative rights.

It 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.

The dbo system role can be granted to other roles with no administrative rights only (WITH NO ADMIN OPTION clause). The WITH ADMIN OPTION and WITH ADMIN ONLY OPTION clauses are not valid for this role.

To grant the dbo system role, execute:

GRANT ROLE dbo TO grantee [,...]