Granting 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. The SYS_SPATIAL_ADMIN_ROLE is the owner of all spatial objects.

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.

It is a member of the PUBLIC system role with no administrative rights only.

The SYS_SPATIAL_ADMIN_ROLE 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_SPATIAL_ADMIN_ROLE system role, execute:
GRANT ROLE SYS_SPATIAL_ADMIN_ROLE TO grantee [,...]
Related reference
GRANT ROLE Statement