Privileges
The dbschema -p command generates information on privileges.
The following syntax diagram fragment shows privileges information.
Privileges
| 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 | 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.