new to security....need help

  • Thread starter Thread starter William Taylor
  • Start date Start date
W

William Taylor

Question.....If I restrict a user group from a table, does it effect a query
based on fields from that table?
I only want a certain group to have access to job numbers and not the
estimated amount. Understand?
Table:
tblJobs
Fields:
JobNum
LineNum
EstimatedLabor
ActualLabor
I want to create a time card form to track how much time was actually spent
on a job without the technician being able to view the estimated amount.
Currently I have to allow access to the Jobs Table. Can I create a query
without the estimatedLabor, allow access to it and then not allow access to
the Jobs Tables? Or are the permissions enherited from the table to the
query?
 
William Taylor said:
Question.....If I restrict a user group from a table, does it effect a query
based on fields from that table?
I only want a certain group to have access to job numbers and not the
estimated amount. Understand?
Table:
tblJobs
Fields:
JobNum
LineNum
EstimatedLabor
ActualLabor
I want to create a time card form to track how much time was actually spent
on a job without the technician being able to view the estimated amount.
Currently I have to allow access to the Jobs Table. Can I create a query
without the estimatedLabor, allow access to it and then not allow access to
the Jobs Tables? Or are the permissions enherited from the table to the
query?
Click to expand...

When queries are created they can be set up to have the current user's
permissions or they can have the permissions of the owner of the query.
When using the latter you can create queries that allow access to tables
that the user does not have permission's to directly.

The property in the query property sheet is named "Run Permissions".
 
Back
Top