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!

Database Vault - How to secure objects

Naveen JVApr 12 2016 — edited Jun 13 2016

Hello Experts,

I am very new to Oracle, using 11gR2 and installed Database Vault in test environment.

Can anyone tell how to achieve security using database vault?

My requirements:

=============

1. All the tables owned by SCOTT should not be accessible to any user other than SCOTT.

2. SCOTT should be able to use the table only through SQL*Net and should not be able to use using any other third part tools like Oracle SQL Developer or TOAD etc.

3. SCOTT should be able to use the tables between 05:00 hrs to 10:00 hrs (IST).

4. Only SCOTT should be able to take dump of these tables.

Please do let me know how to implement this security using Database Vault, please provide me step by step process.

Thanks,

Naveen J V

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 11 2016
Added on Apr 12 2016
5 comments
1,387 views