permissions

  • Thread starter Thread starter lisa
  • Start date Start date
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
 
Huh? How come anyone can even >log in to< a co-worker's account? How do they
know their co-worker's password?

TC
 
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
 
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
 
Back
Top