User, Group, and Role Properties

You can modify an object's properties from its property sheet. To open a user, group, or role property sheet, double-click its Browser entry in the Users, Groups, or Roles folder.

The General tab contains the following properties:

Property

Description

Name

Name of the user, group, or role.

Code

Code of the user, group, or role used as an identifier in the database.

Comment

Description of the user, group, or role.

Stereotype

Sub-classification used to extend the semantics of an object without changing its structure; it can be predefined or user-defined.

Password

[users and groups] Password used for database connection.

The following tabs are also available:

  • Privileges - lists the system privileges granted to the user (see Granting System Privileges).
  • Permissions - lists the operations that the user is permitted to perform on various database objects (see Granting Object Permissions).
  • Users - [groups and roles] Lists the users belonging to the group or role.
  • Groups - [groups and roles] Lists the groups belonging to the group or role.
  • Roles - [roles] Lists the roles belonging to the role.