System Roles

System roles are built-in roles that are automatically created in each new database.

• Granting the dbo System Role
  The dbo system role owns many system stored procedures and views.
• Granting the diagnostics System Role
  Members of the diagnostics system role inherit SELECT, INSERT, UPDATE, DELETE, and ALTER privileges on diagnostic tables and views.
• Granting the PUBLIC System Role
  The PUBLIC system role has SELECT privilege on a set of system tables and EXECUTE privilege on system procedures.
• Granting the rs_systabgroup System Role
  The rs_systabgroup system role owns tables and system procedures that are required for Replication Server, and grants users the underlying system privileges to perform Replication Server functionality.
• Granting the SYS System Role
  The SYS system role owns the system tables and views for the database, which contain the full description of database schema, including all database objects and user IDs.
• Granting the SYS_REPLICATION_ADMIN_ROLE
  The SYS_RUN_REPLICATION_ADMIN_ROLE system role is required for performing administration tasks that are related to replication, such as granting replication roles, managing publications, subscriptions, synchronization users and profiles, managing message types, setting replication-related options, and so on.
• Granting the SYS_RUN_REPLICATION_ROLE
  The SYS_RUN_REPLICATION_ROLE system role is required for performing replication tasks using dbremote, and synchronization tasks using dbmlsync. The SYS_RUN_REPLICATION_ROLE system role is active only for users who connect through these utilities.
• 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.
• Revoking a System Role
  Revokes a system role from a user or role.