Wednesday 12 February 2020

query to check grant on view/table in oracle

SELECT   owner
       , grantee
       , table_name
       , select_priv
       , insert_priv
       , delete_priv
       , update_priv
       , references_priv
       , alter_priv
       , index_priv
    FROM table_privileges
   WHERE table_name = 'SSS_TEMP'
ORDER BY owner
       , table_name;

No comments:

Post a Comment