Database Security Products (MOSC)

MOSC Banner

Hiding column

edited Dec 7, 2011 8:40PM in Database Security Products (MOSC) 14 commentsAnswered ✓
-- In the following scenario:

User1 and User2 has SELECT privileges on UserApp tables whereby the privileges were granted through the use of Database Vault.

apptable contains 5 columns, i.e. ID, DETAILS, SECURE1, SECURE2, REMARKS.

-- Is it possible to hide some columns from User1 when User1 issues a SELECT * FROM apptable? User1 should only see colums ID, DETAILS, REMARKS whereas User2 can see all 5 columns.

Have considered VPD and OLS but they are not relevant in this case as I understand that it restricts which user can see which rows. There is no row restriction imposed for User1 and User2.

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