FGA and BY SESSION auditing

I'm running 11.2.0.4.

I have been able to set up FGA to mimic by session auditing for specific tables.

But to audit SELECT on a table, I have to create a policy for each table. Is there a way

to set up FGA for the schema. I haven't been able to get a schema level"audit select"

 on the schema to work.

James C Allen, Section Chief, MASSDB

Economic Applications Division, U.S. Census Bureau Office 301.763.7501 | Cell 202.604.7286 | Support Line X34944/X30368

Support Dashboard - https://sso.econ.census.gov/dashboard

Telework - None. Available via X37501 and Sametime

census.gov<http://www.census.gov/> Connect with us on Social Media<http://census.gov/about/contact-us/social_media.html>

--
http://www.freelists.org/webpage/oracle-l