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