This topic is locked

Security-Users table versus Main table

1/24/2007 12:06:45 AM
ASPRunnerPro General questions
S
SDDivine author

Just discovered a security issue on record ownership...

In a project, I have several tables...where in most cases I am assigning ownership based upon a field called CLASS
To allow employees to be able to update their own passwords, I built a query and attempted to give ownership to that record by setting the users and main table to LoginID
What I discovered is that no matter which concept I use on one table, the security on the users portion of screen 7 is adjusted for ALL tables. So it doesn't seem to allow me to set up one table on one set of circumstances of security and another on another set of circumstances.
Can you tell me how I can separate this based upon tables? Reference Page 7 of the project..Advanced Section USERS TABLE field verus MAIN TABLE field.
Thanks

Steve Divine

J
Jane 1/24/2007

Steve,
unfortunately it's impossible to use different fields in the Users table as OwnerID.

You can create the second project and use another security settings for this project.

S
SDDivine author 1/24/2007

Steve,

unfortunately it's impossible to use different fields in the Users table as OwnerID.

You can create the second project and use another security settings for this project.


<sad> Guess we can't expect everything...although I was sure hoping. Thanks for the solution, although I'll re-think my design.

Thanks for the quick response.

steve