SCHEMA based privileges and auditing
I need schema based features. (Hopefully Oracle will add this as new feature if not)
grant select any table for SCHEMA to ROLE; (So that privilege does not need to refreshed with dropping and creating tables and other schema objects)
Same:
audit table for SCHEMA; (so all tables for particular get automatically audited whenever created, changed ,dropped or else)
0