Users Editor (Sybase ASE)

From DBArtisan
Jump to: navigation, search

Go Up to Sybase ASE Object Editors

The Users Editor lets you view and modify user definitions and manage associated logins and objects.

To edit a user

  1. Open an editor on the user. 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

Lets you view the user Name and Login Name for the user. Lets you specify a Group Name for the user.

Logins

Lets you assign logins to a user by selecting associated check boxes.

Objects

Lets you manage database objects associated with the user. Objects are organized in a tree structure with folders containing the objects. Optionally, take one of the following actions:

Select an object and click Edit to open an object editor on the selected object.

Select an object and click Drop to initiate dropping the selected object.

Object Permissions and System Permissions

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

Comment

For details on using this tab, see Adding a Comment to an object.

DDL View

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.