Database Administration (MOSC)

MOSC Banner

VPD column masking

edited Dec 12, 2013 10:36AM in Database Administration (MOSC) 15 commentsAnswered
Hi,

I have about 20 tables, each table has one to a few columns, I don't want all the users to access these columns of these tables.

For example, table TEST1 has column1, column 2, column3, column4 and column5, we have 20 users, 15 users can't access column4 and column5, other 5 users can access all the columns for TEST1, can I use VPD to do this?

Currently, I create a view TEST1_VIEW on test1 for column1, column2 and column3 and allow 15 users to access this veiw only. But is VPD a good way do this?

Thanks

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center