SHOW GRANT
From InterBase
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