advanced code snippet search

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

Expand | Embed | Plain Text 
  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.