allow a query to use table but not table to be seen

[tw]

I have a query that uses the employee table to get names etc of employees,
but not pay rate or similar private information. I'm trying to set up a
security schema that allows users to run the employee query, but not have
access to the employee table. The query won't run even though it has full
permission, because there is no permission to the employee table. Any ideas?

Thanks.

 

[Rick B]

You set the query to "run with owner's permission" It is one of the query
properties,

Rick B

 

[tw]

thanks

You set the query to "run with owner's permission" It is one of the query
properties,

Rick B