You can view the roles and privileges a user has, including those that the user inherited through membership in other roles.
This lesson assumes that you have completed all previous lessons in this tutorial. See Lesson 4: Convert User1 to a user-extended role and grant that role to User2 (Sybase Central).
In Sybase Central, double-click Users in the left pane and click User2.
Ensure that the Show Inherited checkbox at the top of the screen is selected.
In the right pane, click the Roles tab to see the roles for User2.
From the screenshot, you can see that User2 has the following roles:
dbo system role User2 has exercise rights, but not administrative rights, on the dbo system role. There is no grantor because User2 is inheriting this system role by being a member of the PUBLIC system role. Users are granted the PUBLIC system role by default when they are created.
DebugAndAlter user-defined role User2 has exercise and administrative rights on the DebugAndAlter role. There is no grantor because User2 is inheriting this user-defined role from User1.
PUBLIC system role User2 has exercise rights on the PUBLIC role. Users are granted the PUBLIC system role by default when they are created. The grantor is DBA because that is what you were logged in as when you created User2.
User1 user-extended role User2 has exercise rights, but not administrative rights, on the User1 user-extended role. The grantor is DBA because that is what you were logged in as when you granted the role to User2.
Click the System Privileges tab to see the system privileges that User2 has. The Grantor column is empty for all of them because the system privileges were inherited, not granted explicitly to User2. The Adm column is empty because no administration rights were granted when the system privileges were granted.
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|