Results 1 to 2 of 2

Thread: sql

  1. #1
    Junior Member
    Join Date
    Aug 2007
    Answers
    2

    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..


  2. #2
    Expert Member
    Join Date
    Jun 2006
    Answers
    410

    Re: sql

    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.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact