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

The SYS 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 SYS system role.

To grant the SYS system role, execute:

GRANT ROLE SYS TO grantee [,...]