permissions

L

lisa

How can security be set up so users have full add, update,
delete permissions on table but can only run query
(report) for their own accounts and not co-workers
accounts?

Thanks.
Lisa
 
T

TC

Huh? How come anyone can even >log in to< a co-worker's account? How do they
know their co-worker's password?

TC
 
L

Lisa

They aren't logging into another account. They are running
report for co-workers user id's which is a field in
the table. I'm trying to find out if there's a way to
prevent that, when they have full access to the table.

Appreciate any info.
Lisa
 
T

TC

Ok. Let me get this straight. Everyone who can log on to your system, has
access to a report. That report lets them enter an account to run the report
for. You only want each user, to be able to run the report for their own
account. You do not want user 'A' to start the report, enter user 'B's name
(or whatever), & thereby run the report for user 'B'.

Is that correct? If so, why let them manually select the account for the
report? Have the report do that, itself. The report could use the
CurrentUser() function to identify the current user. Then it could select
the right account "behind the scenes".

HTH,
TC
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top