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 Perspective Resources view, select the server on which the role resides, then click the drop-down arrow next to the server name and select Administration Console.
  2. In the left pane, expand ASE Servers > Security, then select Users.
  3. Select a role to return privilege to the default system defined values, 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.
  4. 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