Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

view creation in Oracle Audit Vault Server

jewel-dbaMar 7 2021

Hi,
My vendor has instructed me to create a view in Oracle Audit Vault Server as AVSYS user. I am able connect as under :
# su - dvaccountmgr
$ sqlplus /
My queries are :
How I will connect as AVSYS user to create view? What is the default password of AVSYS user.
If I change AVSYS user password , is there any impact in the existing configuration7?
Please help to solve the issue.

Regards,

Jewel

Comments

Ian G Clough

Hi James,
If you make the office's location the identifying attribute for the office (delete the other attribute as it's no longer required) and then your rules can look like this:
Screenshot 2022-04-28 at 10.07.09.pngScreenshot 2022-04-28 at 10.10.07.pngI'm not sure how you might infer other details about the office unless those could be shared rules.
Best regards
Ian

James Woon - Monad

Thanks for that suggestion!
In this case, I have used 'the office location' as an example entity attribute that needs to be populated. But unfortunately, the actually attribute are dates. So maybe something like the office's opening date. We also do need to maintain the identifier (XYZ1, ABC2, etc.).
Therefore, don't think the proposed solution would work :(

Richard Napier

Hello James,
Personally I wouldn't use inclusions. I would use Decision Services. Then I can create two separate decision services, in separate Workspaces, give users permissions, use the Viewer role or the Author role to let people view or edit the Decision Services. Generally I have much more control over them.
image.pngimage.pngI would create references in the OPM project to each of the decision services
image.png
image.png
And create entities to support ABC, XYZ and then the master entity to contain both
image.png
Then I would merge the two entities into one and copy over the location to the master entity.
image.png
image.pngJust my two cents
Have a lovely day

James Woon - Monad

Ah... Decision Services! Sad to say we're on Private Cloud 20C. 
Yes, this is probably the best solution for anyone looking to solve this issue.
(I tried to mark this as answered but it seems I chose 'Discussion' instead of 'Question' for this post)
As always, appreciate your contributions to the community, Richard!

Richard Napier

Ah, I see. I was confused by you saying you had a test project in 21D. Happy to help, James. Whether it be a discussion or a question :)

1 - 5

Post Details

Added on Mar 7 2021
2 comments
356 views