Jamesremec
New member
- Local time
- Today, 23:40
- Joined
- Jul 23, 2002
- Messages
- 8
Hi everyone.
What I'm trying to do is set up a query so that a user can see only the query and not the table it is extracting data from.
I tried using the security wizard and setting the permissions so that the user has access to the query but not to the table. Problem is, when I try to open the query for the user, I get an error that I can't open it because I don't have access to the table that the query is getting the data from. (Hope that makes sense)
Anyways, I'd greatly appreciate it if someone could help me out with this. Please note that the solution does not need to be "bullet proof."
Thanks,
James
What I'm trying to do is set up a query so that a user can see only the query and not the table it is extracting data from.
I tried using the security wizard and setting the permissions so that the user has access to the query but not to the table. Problem is, when I try to open the query for the user, I get an error that I can't open it because I don't have access to the table that the query is getting the data from. (Hope that makes sense)
Anyways, I'd greatly appreciate it if someone could help me out with this. Please note that the solution does not need to be "bullet proof."
Thanks,
James