Granting the SYS_SPATIAL_ADMIN_ROLE System Role

The SYS_SPATIAL_ADMIN_ROLE system role grants users the ability to create, alter, drop, or comment on spatial reference systems and spatial units of measure. SYS_SPATIAL_ADMIN_ROLE is the owner of all spatial objects.

Prerequisites
MANAGE ROLES system privilege.
Task

By default, the SYS_SPATIAL_ADMIN_ROLE system role is granted the MANAGE ANY SPATIAL OBJECT system privilege with no administrative rights.

You can grant the SYS_SPATIAL_ADMIN_ROLE 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 SYS_SPATIAL_ADMIN_ROLE system role.

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

To grant the SYS_SPATIAL_ADMIN_ROLE system role, execute:
GRANT ROLE SYS_SPATIAL_ADMIN_ROLE TO grantee [,...]
Related reference
GRANT ROLE Statement