View the roles and privileges have been granted to users and to roles.
Prerequisites
You must have the PUBLIC role.
Procedure
- In SQL Central, use the SQL Anywhere 17 plug-in to connect to the database.
- Choose one of the following options:
| Option |
Action |
|---|
| View the roles and privileges for a user
|
-
In the left pane, double-click Users.
-
Click the user you want to view.
-
To view the user's roles and system privileges, in the right pane, click Roles and System Privileges, respectively.
-
To view the user's object-level privileges, click any of the remaining privileges tabs (such as Table privileges, View privileges, and so on).
|
| View the roles and privileges for a role
|
-
In the left pane, double-click Roles.
-
Click the role you want to view.
-
To view the roles and system privileges, in the right pane, click Roles and System Privileges, respectively.
-
To view the role's object-level privileges, click any of the remaining privileges tabs (such as Table privileges, View privileges, and so on).
|
- Optionally, select Show Inherited to include inherited roles and privileges.
Results
The right pane displays the roles and privileges that have been granted to, or inherited by, the specified user or role.
