Skip to Main Content
  • Questions

  • divide data in database with specific login id

Breadcrumb

Question and Answer

Chris Saxon

Thanks for the question, mellad.

Asked: September 15, 2016 - 12:29 pm UTC

Last updated: September 15, 2016 - 1:01 pm UTC

Version: 5

Viewed 1000+ times

You Asked

Hi
we have five projects that their all data saved in some tables in database, is there any way so that each project end user should only be able to access only their own project data, and must not able able access any other projects data.

and Chris said...

Provided you have a way to identify which rows belong to which user you could use Virtual Private Database (VPD).

Using this you can setup security policies controlling who can see what.

If you want to know more about this see:

http://docs.oracle.com/database/121/DBSEG/vpd.htm#DBSEG007
https://oracle-base.com/articles/8i/virtual-private-databases
http://www.oracle.com/technetwork/database/security/index-088277.html

Note this an Enterprise Edition feature.

Is this answer out of date? If it is, please let us know via a Comment
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.

More to Explore

Security

All of the vital components for a secure database are covered in the Security guide.