RE: What DB privs are required to read an EM13r2 SYSMAN view in 12.2?
Date: Tue, 12 Dec 2017 06:57:59 +0000
Message-ID: <20412_1513061889_5A2F7E01_20412_10024_1_ECDEF0CC6716EC4596FCBC871F48292AB1921494_at_ZRH-S231>
In my previous e-mail I’ve forgotten to mention that there is an alternative to granting “exempt access policy”. What I mean by that is if you create the reporting user through EM GUI with the read access to all of the targets it’ll get the correct VPD context. This was most probably the case before, as the VPD privileges don’t survive the datapump export/import.
Nenad
Twitter:_at_NenadNoveljic
Home page: http://nenadnoveljic.com/blog/
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Rich J
Sent: Montag, 11. Dezember 2017 14:36
To: oracle-l_at_freelists.org
Subject: Re: What DB privs are required to read an EM13r2 SYSMAN view in 12.2?
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
Please consider the environment before printing this e-mail. Bitte denken Sie an die Umwelt, bevor Sie dieses E-Mail drucken.
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css">p { font-family: Arial;font-size:9pt }</style>
</head>
<body>
<p>
<br>Important Notice</br>
<br>This message is intended only for the individual named. It may contain confidential or privileged information. If you are not the named addressee you should in particular not disseminate, distribute, modify or copy this e-mail. Please notify the sender immediately by e-mail, if you have received this message by mistake and delete it from your system.</br>
<br>E-mail transmission may not be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete. Also processing of incoming e-mails cannot be guaranteed. All liability of the Vontobel Group and its affiliates for any damages resulting from e-mail use is excluded. You are advised that urgent and time sensitive messages should not be sent by e-mail and if verification is required please request a printed version.<br/>
</p>
</body>
</html>
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Dec 12 2017 - 07:57:59 CET