Role Wizard (Sybase ASE)

From DBArtisan
Jump to: navigation, search

Go Up to Sybase ASE Object Wizards

Roles are sets of user privileges you associate with access to objects within a database. Roles streamline the process of granting permissions. You can use roles to grant sets of permissions and privileges to users and groups. Roles can help you comply with Sarbanes Oxley regulations by limiting which users can have access to what privileges, for example a Human Resources Role versus an Accounting Role.

To create a new role using a wizard:

  1. Open an object creation wizard for a role. For details, see Opening an Object Wizard.
  2. Use the following topics as a guide to setting properties and performing tasks as you pass through the wizard panels:
  3. Finally, use the Execute button to create the object.

After creating a role, you can use the Roles Editor to assign the role to logons or other roles. For details, see Roles Editor (Sybase ASE).

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

Roles (Sybase ASE) - Properties

When creating or editing a role, this tab/panel lets you work with the following settings:

Settings Description

Name

The name of the role?

Password

Enter the password, if any, that must be entered to activate the role (seven characters is the default).

Password Expiration

Enter the time, in days, after which users must change the password

Minimum Password Length

Enter the minimum password length, if any.

Maximum Failed Logins

Enter the minimum number of login attempts, if any, after which the role is locked out.