Re: Row Level Locking

The solution to your problem is not row-level locking. Locking has to do with correct execution of concurrent accesses. Your issue is about security and permissions. You might want to set up views, e.g., "select * from <table> where Mgr-id= 5", and then give manager "5" access only to that view but not to the entire table.

Goetz Graefe

Dan Slater wrote in message <6u6cuo$fdg$1_at_lore.csc.com>...
>I'm developing a db to be accessed from the web. It's been recommended to
>me to use Cold Fusion w/Access or SQL server.
>
>However, the core requirements of this db is to allow a manager to log on
>and view/edit ONLY the employees that report to him/her (usually around 25
>employees per manager out of a 7500 record table).
>
>Is "Row Level Locking" what I'm trying to do?
>
>My experience with db's outside of Access is limited. Can anyone help?
>
>Dan Slater
>dslater2_at_cscmail.csc.com
>
>
>
Received on Thu Sep 24 1998 - 00:00:00 CEST