Advanced Search

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

Expand | Embed | Plain Text

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.