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 5: View the roles and privileges for User2 (Sybase Central)

You can view the roles and privileges a user has, including those that the user inherited through membership in other roles.

Prerequisites

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

 Task

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

  2. Ensure that the Show Inherited checkbox at the top of the screen is selected.

  3. In the right pane, click the Roles tab to see the roles for User2.

    Shows the system privileges inherited by 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.

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

    Shows the object-level privileges that User2 has.

Results

You have verified the roles, privileges, and administrative rights for User2.

 See also
Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0