Advertisement
Guest User

Untitled

a guest
Aug 31st, 2016
76
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.33 KB | None | 0 0
  1. object_name column_name user group privilege
  2. --------------------------------------------------------------------------
  3. TABLE_1 Column_1 admin SEL
  4. TABLE_1 Column_2 admin SEL,UPD
  5. TABLE_1 Column_4 admin SEL
  6. TABLE_2 Column_1 user_1 DEL
  7.  
  8. select * from _v_relation_column
  9. where NAME NOT IN ('V_GROUP_PRIVS','V_USER_PRIVS')
  10. AND TYPE NOT LIKE '%SYSTEM%'
  11. AND TYPE NOT LIKE '%MANAGEMENT%'
  12. AND TYPE='VIEW';
  13.  
  14. 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
  15. ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
  16. 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
  17. 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
  18. 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