## MD_PRIVILEGES

Columns
Constraints
Grants
Statistics
Triggers
Dependencies
Details
Partitions
Indexes

COLUMN_NAME | DATA_TYPE | NULLABLE | DATA_DEFAULT | COLUMN_ID | PK | COMMENTS
--- | --- | --- | --- | --- | --- | ---
ID | NUMBER | No | null | 1 | 1 | Primary Key
SCHEMA_ID_FK | NUMBER | No | null | 2 | null | The schema to which this object belongs //PARENTFIELD
PRIVILEGE_NAME | VARCHAR2(4000 BYTE) | No | null | 3 | null | The name of the privilege //OBJECTNAME
PRIVELEGE_OBJECT_ID | NUMBER | Yes | null | 4 | null | This references the table, view, etc on which the privelege exists. This can be NULL for things like system wide privileges
PRIVELEGEOBJECTTYPE | VARCHAR2(4000 BYTE) | No | null | 5 | null | The type the privelege is on (e.g. INDEX)
PRIVELEGE_TYPE | VARCHAR2(4000 BYTE) | No | null | 6 | null | e.g.select
ADMIN_OPTION | CHAR(1 BYTE) | Yes | null | 7 | null | Flag to show if this was granted with admin option. 'Y' means it was granted with admin option 'N' means it was NOT granted with admin option. NULL means not applicable (e.g. not known, not supported by source platform, etc.)
NATIVE_SQL | CLOB | No | null | 8 | null | The SQL used to create this privilege at source
NATIVE_KEY | VARCHAR2(4000 BYTE) | Yes | null | 9 | null | An identifier for this object at source.
COMMENTS | VARCHAR2(4000 BYTE) | Yes | null | 10 | null | null
SECURITY_GROUP_ID | NUMBER | No | 0 | 11 | null | null
CREATED_ON | DATE | No | sysdate | 12 | null | null
CREATED_BY | VARCHAR2(255 BYTE) | Yes | null | 13 | null | null
LAST_UPDATED_ON | DATE | Yes | null | 14 | null | null
LAST_UPDATED_BY | VARCHAR2(255 BYTE) | Yes | null | 15 | null | null