Home | Previous Page | Next Page   Data Migration Utilities > The dbschema Utility >

Privileges

Read syntax diagramSkip visual syntax diagramPrivileges:
 
|-- -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 ]