Privileges: |-- -p--+-user-+------------------------------------------------| '-all--'
| Element | Purpose | Key Considerations |
|---|---|---|
| -p user | Displays the GRANT statements that grant privileges to user, where user is a user name or role name. Specify only one user or role | Restriction: You cannot specify a specific list of users with the -p option. You can specify either one user or role, or all users and roles. |
| -p all | Displays the GRANT statements for all users for the database, table, or view specified, or to all roles for the table specified | None. |
The output also displays any GRANT FRAGMENT statements that are issued for a specified user or role or (with the all option) for the entire schema.
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]