Security

[Rob Lobbe]

John,

If you are using a database, you can create a simple view that only selects
those records that meet the "location code" restrictions. You obviously
already have user related security.

tbl_Security
UserName    AccessCode

tbl_LotsOfData
AccessCode    LotsofDetail

view_Restricted
select * from tbl_LotsOfData where AccessCode in
  (select AccessCode from tbl_Security where UserName = CURRENT_USER)


Rob Lobbe
rlobbe@vic.bigpond.net.au
PowerHouse Practice Manager
Praxa Ltd

= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
This list is closed, thus to post to the list, you must be a subscriber.