flashback table and row-level security:
- From: Paul Baumgartel <paul.baumgartel@xxxxxxxxx>
- To: Oracle-L Freelists <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 25 May 2005 17:46:03 -0400
This is just an FYI. Oracle 10.1.0.4.0 on Windows.
User A has all privileges necessary to flash back user B's tables.=20
Some of User B's tables are protected by a row-level security policy.=20
User A's attempt to flash back those tables fails with
ORA-08194: Flashback Table operation is not allowed on materialized views=
=20
(Needless to say, these are not materialized views).=20
After removal of the RLS policies, User A was able to flash back all
of User B's tables successfully.
--=20
Paul Baumgartel
paul.baumgartel@xxxxxxxxxxxx
--
//www.freelists.org/webpage/oracle-l
Other related posts:
- » flashback table and row-level security:
