The owner of the database can list all user identifiers and assigned permissions by using the LIST ACCESS command. The owner can list access rights for a particular user, for a permission type, for a table, or for all permissions. A user can list their permissions only. Some of the LIST ACCESS options an owner can use include:
To display all access rights granted for the entire database, use:
LIST ACCESS
To display all access rights granted to all tables for the specified user, use:
LIST ACCESS FOR <username>
To display all access rights granted to all users for the specified table, use:
LIST ACCESS ON <tablename>
To display all access rights granted for all users and all tables with the specified permission, use:
LIST ACCESS permission
