× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



>> Has anyone implemented a system that supports row-level security? 
<< ..snip>>
>> Any experience or places to look for decent design patterns?

I have seen an application called HRizon that has an interesting way to deal 
with this kind of security.  It is not exactly what you want, but it is close.

Basically, you maintain a security table, which has the user and the various 
fields that you want to do row level security against.  Then you do your actual 
operations against a JOIN of the file to be secured and the security file.

Simple example --

SECURITY file
  User
  Authorized Sales Rep
  Sales Rep Update?
  Authorized Item Class
  Item Class Update?

CUSTOMER file
  Customer#
  . . . various other fields
  Sales Rep

ITEM file
  User
  . . . fields
  Item Class

For Customer Inquiry , use a JOIN of CUSTOMER to SECURITY.  For update, use a 
JOIN of CUSTOMER to SECURITY where Sales Rep Update? = Yes.

Take care.

THIS MESSAGE IS INTENDED ONLY FOR THE USE OF THE INDIVIDUAL OR ENTITY TO WHICH 
IT IS ADDRESSED AND MAY CONTAIN INFORMATION THAT IS PRIVILEGED, CONFIDENTIAL 
AND EXEMPT FROM DISCLOSURE UNDER APPLICABLE LAW.  If the reader of this message 
is not the intended recipient, or the employee or agent responsible for 
delivering the message to the intended recipient, you are hereby notified that 
any dissemination, distribution, copying, downloading, storing or forwarding of 
this communication is prohibited.  If you have received this communication in 
error, please notify us immediately via email and delete the message from your 
computer files and/or data base.  Thank you.


As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.