Home » RDBMS Server » Security » Encryption only one column
Encryption only one column [message #216830] Tue, 30 January 2007 11:18 Go to next message
Teresa
Messages: 36
Registered: May 2002
Member
Hello

I would like to do a encryption of one column only for all users except one that should have all permissions, oracle 10GR2 on solaris, is this possible?

Thank you
Teresa
Re: Encryption only one column [message #220101 is a reply to message #216830] Sun, 18 February 2007 20:07 Go to previous messageGo to next message
nmacdannald
Messages: 460
Registered: July 2005
Location: Stockton, California - US...
Senior Member
Yes. Try looking at views to hid columns. Grant to only the users you want. Create a synonym to hide the fact that other users are looking at you view that does not contain that column.
Re: Encryption only one column [message #220110 is a reply to message #216830] Sun, 18 February 2007 21:56 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
You may also want to consider Column Masking that is available in Oracle 10gR2.
Previous Topic: PASSWORD_REUSE_TIME versus PASSWORD_REUSE_MAX
Next Topic: How can I allow a user to change their Oracle DB password?
Goto Forum:
  


Current Time: Sat Apr 20 02:51:12 CDT 2024