Granting SYS System Role

The SYS role owns the system tables and views for the database, which contain the full description of database schema, including all database objects and all user IDs.

Prerequisites

Requires the MANAGE ROLES system privilege.

Task

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

The SYS 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 SYS system role, execute:

GRANT ROLE SYS TO grantee [,...]