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 |