Ver tablas asignadas a un usuario por privilegios


/ Published in: SQL
Save to your folder(s)

ver tablas que tiene un usario asiganadas por privilegio


Copy this code and paste it in your HTML
  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


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.