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.

Prerequisites

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).

Task

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.
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.

Results

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

Next

Proceed to Lesson 5: View the roles and privileges for User2 (Sybase Central).

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

Task

See also