permissions to edit or add new records pertaining to their own organization.

April 26, 2007 by satheesh Dominic

If you want the users to change/Update only their own details you have to limit the recordset results.

For that, you can try this simple logic:

Once the user logs in, you should store the username in a session variable. Mostly in Dreamweaver the user session variable will be "MM_Username".

Now you have the session for that particular user. Once the user logs out...this session also will get expire.

Now..you proceed to modify the recordset which you are using to modify the database entries.....Once you set the recordset to filter by the Username colmn in the database as follows. 

Note: The Session Variable is chosen...

Now this recordset will display only a result where the session variable (MM_Username) = the Database colmn....This way you can limit the users to modify only their own data