Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - Database Administration » User and database security » User security (roles and privileges) » Tutorial: Granting roles and privileges (Sybase Central)


Lesson 4: Convert User1 to a user-extended role and grant that role to User2 (Sybase Central)

Assume that you want User2 to have the same privileges and roles as User1. Rather than going through the same lengthy process of explicitly granting the roles and privileges as you did with User1, you can convert User1 to a user-extended role and grant that role to User2. User1 continues to be a user who can log in to the database, in addition to being a role.


This lesson assumes that you have completed all previous lessons in this tutorial. See Lesson 3: Create a role and grant it to User1 (Sybase Central).

  1. Convert User1 to a user-extended role.

    1. In the left pane in Sybase Central, double-click Users and click User1.

    2. Right-click anywhere in the right pane and click Change to User-extended Role.

  2. Grant the user-extended role User1 to User2.

    1. In the left pane, double-click Users and click User2.

    2. Click the Roles tab.

    3. Right-click anywhere on the tab and click New » Granted Roles.

    4. Click User1, then click OK.

    5. Click File » Save to save your changes to the database.


User1 has been converted to a user-extended role and has been granted to User2.

 See also