Controlling access to confidential data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I have a table containing salary information. I would like to give people
access to queries which show only the parts of the data they are responsible
for and not the rest of the data. I have set up a number of queries which
query the table, and restricted access to each query to one use, using the
user / group positions security feature. I cannot get these queries to run
unless I give the users read access to the table also - which defeats the
object. Can anyone help? Thanks
 
HRman said:
Hello,

I have a table containing salary information. I would like to give people
access to queries which show only the parts of the data they are
responsible
for and not the rest of the data. I have set up a number of queries which
query the table, and restricted access to each query to one use, using the
user / group positions security feature. I cannot get these queries to run
unless I give the users read access to the table also - which defeats the
object. Can anyone help? Thanks
Click to expand...

User "run with owner permission" queries - remove the permissions from the
tables and (in query design view) set the query "run" permission to
"owners".

HTH - Keith.
www.keithwilby.com
 
Back
Top