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).
Convert User1 to a user-extended role.
In the left pane in Sybase Central, double-click Users and click User1.
Right-click anywhere in the right pane and click Change to User-extended Role.
Grant the user-extended role User1 to User2.
In the left pane, double-click Users and click User2.
Click the Roles tab.
Right-click anywhere on the tab and click New » Granted Roles.
Click User1, then click OK.
Click File » Save to save your changes to the database.
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|