HiveBrain v1.2.0
Get Started
← Back to all entries
patternMinor

Does Oracle support table-level & column-level permissions?

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
permissionscolumnleveldoesoracletablesupport

Problem

If there is a customer table, and some extra-private/secure information like SSN is there, should I create another table to store such information and lock that table so only certain people can view it even though it's strictly one-to-one? or can columns be locked too from unauthorized viewing based on rights?

Even if both types of security mechanism do exist, is one preferred over the another? I might have said something very vague but I've used SQL Server more often.

Solution

Create a view which simply selects all the other columns form the table in question excluding the columns that you don't want the people to have access to. Give them rights to query the view and not the table.

Context

StackExchange Database Administrators Q#17077, answer score: 6

Revisions (0)

No revisions yet.