SYSTABLEPRIVILEGES
From Recital Documentation Wiki
Revision as of 16:04, 13 March 2009 by Yvonnemilne (Talk | contribs)
Contents
SYSTABLEPRIVILEGES
Class
SQL Applications
Purpose
Description of the access rights for each table available in the catalog
See Also
DATA TYPES, SELECT, SYSTEM TABLES
Description
System Tables are system defined read-only tables. You can query these tables using the SELECT statement.
| Column | Data Type | Width | Description |
|---|---|---|---|
| TABLE_CAT | C | 30 | Table catalog |
| TABLE_SCHEM | C | 30 | Table schema |
| TABLE_NAME | C | 30 | Table name |
| GRANTOR | C | 30 | Grantor of access |
| GRANTEE | C | 100 | Grantee of access |
| PRIVILEGE | C | 30 | Name of access (SELECT, INSERT etc) |
| IS_GRANTABLE | C | 3 | "YES" if grantee is permitted to grant to others; "NO" if not; .NULL. if unknown. |
Example
EXEC SQL SELECT * FROM systableprivileges;
Products
Recital Database Server, Recital Mirage Server, Recital Terminal Developer
