Posted By

thescorpion on 11/14/12


Tagged

sql Oracle DBA privilegios


Versions (?)

Ver tablas asignadas a un usuario por privilegios


 / Published in: SQL
 

ver tablas que tiene un usario asiganadas por privilegio

  1. SELECT owner, table_name, select_priv, insert_priv, delete_priv, update_priv, references_priv, alter_priv, index_priv
  2. FROM table_privileges
  3. WHERE grantee = 'AUDITOR'
  4. ORDER BY owner, table_name;

Report this snippet  

You need to login to post a comment.