SHOW GRANT
Go Up to isql Command Reference
Displays privileges for a database object.
SHOW GRANT object;
| Argument | Description |
|---|---|
|
<object> |
Name of an existing table, view, or procedure in the current database |
Description: SHOW GRANT displays the privileges defined for a specified table, view, or procedure. Allowed privileges are DELETE, EXECUTE, INSERT, SELECT, UPDATE, or ALL. To change privileges, use the SQL statements GRANT or REVOKE.
Before using SHOW GRANT, you might want to list the available database objects. Use SHOW PROCEDURES to list existing procedures; use SHOW TABLES to list existing tables; use SHOW VIEWS to list existing views.
Example: To display GRANT privileges on the JOB table, enter:
SHOW GRANT JOB;
GRANT SELECT ON JOB TO ALL
GRANT DELETE, INSERT, SELECT, UPDATE ON JOB TO MANAGER
SHOW GRANT can also show role membership:
SHOW GRANT DOITALL;
GRANT DOITALL TO SOCKS