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