Hello, i am looking for a way to view all the privileges that have been granted on a materialized view in oracle. I know with tables you can do this:
select Grantee, privilege from dba_tab_privs where table_name='tablename'
But when i do this with a materialized view(substitute the name of the view in for the table name), it returns nothing. Does anyone know how i can do this. It must be done using sql as i'm using it in a script.
Thank You in advance.