Roles Editor (Sybase ASE)

From RapidSQL
Jump to: navigation, search

Go Up to Sybase ASE Object Editors

The Roles Editor lets you manage authentication, logins, and privileges for a role.

Note: User-defined roles are available in Sybase ASE 11.5 or later.

To edit a role

  1. Open an editor on the role. For details, see Opening an Object Editor.
  2. Use the following table as a guide to understanding and modifying the settings on the tabs of this editor:
Tab Settings and tasks

Properties

Displays the role Name, and lets you wok with the Password, Password Expiration, Minimum Password Length, and Maximum Failed Logins settings. For detailed information on these settings, see Roles (Sybase ASE) - Properties. This tab also lets you work with the following settings:

Apply Server Wide

Displays whether the maximum failed logins server configuration parameter has been set. If Apply Server Wide is unselected, the Maximum Failed Logins setting applies only to the current role. For information on setting the maximum failed logins configuration parameter, see Session Recording.

Role Locked

Lets you manually lock the role.

Logins/Roles

Displays the logins or roles that have been granted to this role in the Objects that have this Role granted list. Other roles and logins available to be granted to this role are shown in the Objects that don’t have this Role granted list. Optionally, you can:

Use the Logins/Roles radio boxes to toggle the two lists between logins and roles display.

Grant a login or another role to this role by selecting the login/role from the Objects that don’t have this Role granted list and clicking Grant.

Revoke a login or role from this role by selecting the login/role from the Objects that have this Role granted list and clicking Revoke.

Object Privileges and System Privileges

For details on using these tabs, see Working with Privileges and Permissions.

DDL

For details on using this tab, see Viewing the SQL/DDL for an Object.

3. When finished, you can submit your changes. For details, see Previewing and Submitting Object Editor Changes.

For information on activating and deactivating roles for the current login in the current session, see Role Activation.