M
Me
I would like to restrict modifications to a table (Say TableA) based on
userid.
I have user information allowed to modify records in TableA in another table
say TableB. The two table are connected with a key.
If I write a query joining two tables to pull up records that the logged user
can modify, then I cannot modify the records since it is a join on two tables.
Another way would be for users to enter the Key for the 1st table and
then I verify if the user is allowed to modify the requested record.
Our users here don't want to do that, they want to view all the records they
are authorized to modify and then modify the record if they choose to do so.
How can this be accomplished?
Thank you,
-Me
userid.
I have user information allowed to modify records in TableA in another table
say TableB. The two table are connected with a key.
If I write a query joining two tables to pull up records that the logged user
can modify, then I cannot modify the records since it is a join on two tables.
Another way would be for users to enter the Key for the 1st table and
then I verify if the user is allowed to modify the requested record.
Our users here don't want to do that, they want to view all the records they
are authorized to modify and then modify the record if they choose to do so.
How can this be accomplished?
Thank you,
-Me