Chapter 13 Managing Database Access

Creating a user

You need to create a user before you can attach him/her to an object or define his/her permissions. Users have the following properties:

Property Description
Name Name of the user
Code Code of the user used as identifier in the database
Comment Descriptive label for the user
Stereotype Sub-classification used to extend the semantics of an object without changing its structure; it can be predefined or user-defined
Password Password that may be used for database connection

A comprehensive definition of a user also includes privileges and permissions over database objects; these topics are explained in sections Managing system privileges and Managing object permissions.

Steps To create a user:

  1. Select Model→Users and Roles→Users.

    The List of Users appears.
  2. Click a blank line in the list.

    or

    Click the Add a Row tool.

    An arrow appears at the beginning of the line.
  3. Click Apply.
  4. Click the Properties tool.

    The user property sheet appears.
  5. Type a user name and a user code.
  6. Type a user password for further database connection.
  7. Click OK.

 

Copyright (C) 2005. Sybase Inc. All rights reserved.