Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- object_name column_name user group privilege
- --------------------------------------------------------------------------
- TABLE_1 Column_1 admin SEL
- TABLE_1 Column_2 admin SEL,UPD
- TABLE_1 Column_4 admin SEL
- TABLE_2 Column_1 user_1 DEL
- select * from _v_relation_column
- where NAME NOT IN ('V_GROUP_PRIVS','V_USER_PRIVS')
- AND TYPE NOT LIKE '%SYSTEM%'
- AND TYPE NOT LIKE '%MANAGEMENT%'
- AND TYPE='VIEW';
- OBJID NAME OWNER CREATEDATE TYPE DATABASE ATTNUM ATTNAME COLID DESCRIPTION FORMAT_TYPE ATTNOTNULL ATTTYPID ATTTYPMOD ATTLEN ATTDISPERSION COLDEFAULT ATTCOLLENG ATTDELIM ZMAPPED OBJCLASS RELRESTOREDOID OBJDELIM ATTVERSTATUS ATTORIGOID ATTRESTOREDOID OBJDB SCHEMA SCHEMAID
- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
- 202822 VIEW1 ADMIN 2016-08-29 07:41:31.0 VIEW BENCHQADS 3 DEPARTMENT_NAME 209003 <null> CHARACTER(20) true 1042 32 -1 0 <null> 20 false false 4906 0 false 0 0 0 200586 ADMIN 200585
- 202822 VIEW1 ADMIN 2016-08-29 07:41:31.0 VIEW BENCHQADS 3 JOB_CODE 209002 <null> CHARACTER(20) false 1042 15 -1 0 <null> 20 false false 4906 0 false 0 0 0 200586 ADMIN 200585
- 202822 VIEW1 ADMIN 2016-08-29 07:41:31.0 VIEW BENCHQADS 1 EMPLOYEE_NUMBER 209001 <null> INTEGER true 23 -1 4 0 <null> 4 false false 4906 0 false 0 0 0 200586 ADMIN 200585
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement