Use the LIST ACCESS command to allow the owner of a database to view all user's access rights assigned by the GRANT command, and to allow users to view their access rights and rights granted to PUBLIC.
Options
ALL
Displays the users and tables to which the ALL PRIVILEGES access right has been assigned.
ALTER
Displays the users and tables to which the ALTER access right has been assigned.
CREATE
Displays the users and tables to which the CREATE access right has been assigned.
DELETE
Displays the users and tables to which the DELETE access right has been assigned.
FOR user
Displays the tables and access rights for a specific user.
INSERT
Displays the users and tables to which the INSERT access right has been assigned.
ON tblview
Displays the users and their access rights for a specific table or view.
REFERENCES
Displays the users who have rights to reference a primary-key or unique-key table.
SELECT
Displays the users and tables to which the SELECT access right has been assigned.
UPDATE
Displays the users, tables, and columns to which the UPDATE access right has been assigned.
About the LIST ACCESS Command
The LIST ACCESS command is available when access rights have been granted. When access rights have been granted with the WITH GRANT OPTION, the LIST ACCESS command displays an asterisk in front of the access right. When the LIST ACCESS command is entered without any options, it displays all access rights that have been granted on all tables to which the current user identifier has access.
The LIST ACCESS command requires a user identifier-either the database owner's, user's, or NONE. When you enter the owner's user identifier, the LIST ACCESS command allows you to view all current access rights assigned with the GRANT command. When you enter your user identifier, the LIST ACCESS command displays only the access rights granted to PUBLIC and to you. Users other than the database owner who are assigned access rights with the WITH GRANT OPTION are able to display the access rights they grant to other users.
Examples
The following commands assign access rights.
GRANT INSERT ON employee TO mike, dale
GRANT SELECT, INSERT ON transmaster TO dawn +
WITH GRANT OPTION
GRANT UPDATE ON transmaster TO andrea
GRANT UPDATE (company, custaddress, custcity) +
ON customer TO mike, PUBLIC
Based on the access rights assigned with the GRANT commands above, the LIST ACCESS command would display the information below. Column names listed under Column are columns that are specified with the UPDATE access right. Columns are only displayed when a user has been assigned UPDATE rights to specific columns.
Based on the access rights assigned with the GRANT commands above, the LIST ACCESS UPDATE command would display the information below.
Based on the access rights assigned with the GRANT commands above, the LIST ACCESS ON transmaster command would display the information below. The asterisk (*) by SELECT and INSERT shows that Dawn can grant those access rights to other users.
