Bert Gombos
Member²
In a table editor window it's not possible to add/modify/revoke some kind of privileges, for example QUERY REWRITE.
Try this:
select t.privilege, count(*)
from dba_tab_privs t,
dba_objects t2
where t.owner = t2.owner
and t.table_name = t2.object_name
and t2.object_type = 'TABLE'
group by t.privilege
Try this:
select t.privilege, count(*)
from dba_tab_privs t,
dba_objects t2
where t.owner = t2.owner
and t.table_name = t2.object_name
and t2.object_type = 'TABLE'
group by t.privilege
