Controlling access to confidential data

[HRman]

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

 

[Keith W]

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

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