Restoring System Roles

Return system role privilege to the default system-defined values.

Prerequisites

See Enabling Granular Permissions.

You must have the manage security permissions system privilege to restore system roles and manage server permissions to restore sa_role privileges.

Task
  1. In the left pane of the Administration Console, expand ASE Servers > Security > Roles.
  2. Click the Name field of the role, then click the drop-down arrow and select Restore System Role.
    These system roles can be restored: sa_role, sso_role, oper_role, replication_role, keycustodian_role.
  3. Choose to restore the privileges for the selected role on the current database or for all online databases and click OK.
Related concepts
Enabling Granular Permissions