Find Oracle priv’s GRANTed to a table

One I can’t seem to remember (obviously until I write it down here). When trying to find out the privilidges that have been granted to a table in Oracle use the DBA_TAB_PRIVS view:

SELECT * FROM DBA_TAB_PRIVS where table_name = 'TABLE' and owner = 'SCHEMA'

Add comment

Loading