Grant v Deny

I just created 3 sensitive data tables within my database. I have a Group that conatins multiple people and only 5 of those can have access to these tables new tables. The rest of the people in the group need Read access to all of the other tables within this database. These 5 people also need to be able to Read the reaming tables also.


What are my options? examples would be great..


TIA

.

Relevant Pages

  • Re: rolling Firefox back to 2.x
    ... from outside Firefox. ... If you want to be sure that all sensitive data ... shell code) to create a new database and copy the data you want to keep. ... private information on a computer you are sharing with other people. ...
    (Ubuntu)
  • Re: rolling Firefox back to 2.x
    ... from outside Firefox. ... If you want to be sure that all sensitive data ... shell code) to create a new database and copy the data you want to keep. ... untraceable by forensic analysis of your hard drive? ...
    (Ubuntu)
  • Re: hide SOME query results for unauthorized users
    ... database to make it impossible to open without the password. ... confused about is how to set-up a "login" procedure. ... (but typically only the users who are generating the sensitive data) ... queries how do I allow some but not all users to see the flagged records. ...
    (microsoft.public.access.queries)
  • Re: Add a default form for start-up
    ... "Andy" wrote: ... > Make the sensitive data not readable by anyone except the db Administrator. ... >> The main database has very sensitive material in it. ... Each manager is only ...
    (microsoft.public.access.modulesdaovba)
  • Server setup file encryption
    ... Our webapplication needs to access highly sensitive data. ... currently there are 2 boxes, 1 MySQL database server and 1 Apache webserver (with sensitive data) both running Linux. ...
    (Security-Basics)