Re: What DB privs are required to read an EM13r2 SYSMAN view in 12.2?
From: Rich J <rjoralist3_at_society.servebeer.com>
Date: Mon, 11 Dec 2017 07:35:51 -0600
Message-ID: <41471419fd36097386b74901149aea02_at_society.servebeer.com>
Date: Mon, 11 Dec 2017 07:35:51 -0600
Message-ID: <41471419fd36097386b74901149aea02_at_society.servebeer.com>
On 2017/12/11 01:48, Noveljic Nenad wrote:
> Use "exempt access policy" to bypass the VPD.
Yeah, I figured that out through trial-and-error. Either I missed something in the datapump export/import of that schema from the EM12 repository DB or the Policy is new for EM13r2. In any case, I blew away the schema, re-created it as an Administrator via EM13r2, granted it READ on other tables/views and all is well.
Thanks for the reply!
Rich
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Dec 11 2017 - 14:35:51 CET