Thread: sql

i have a top secret employeee,while iam selecting some employees,ihave to hide all his details,how can i do it,and is there any chance to hide only the salary column.this is all using sql.can anybody help me please..

There are so many ways to achieve this in oracle.

1. create a view on the table only with those rows and columns that you want to share. Don't give any access privilege on table instead allow the users to access the view.

2. It is easy to hide a column like salary or SSN. Oracle 10g has come up with native encryption. It is very easy to use.