Chapter 13 Managing Database Access


Creating a role

A role is identified by a name and a code.

A comprehensive definition of a role 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 role:

  1. Select Model→Users and Roles→→Roles.

    The List of Roles 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 role property sheet appears.
  5. Type a role name and code.
  6. Click OK.

 


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