1. Data Set This would come from a separate legacy application that stores information against a client number. 2.) We were thinking a stored procedure as we could link this in with the legacy application (legacy app would still be in use providing some data). Also from what we've seen would be a secure approach. 3. Thought I would clarify sorry. More after if people would do it this way or not still looking a which way to do this sort of thing.
________________________________ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ishai Sagi Sent: Monday, 5 May 2008 12:54 PM To: [email protected] Subject: [OzMOSS] RE: Question re limiting data set with stored procedure I am a bit confused as to what you are doing. 1. What "data set"? 2. why a stored procedure? (you are not supposed to access the database directly - instead use the object model) 3. Why should authentication via internet matter? From: [EMAIL PROTECTED] om [mailto:[EMAIL PROTECTED] On Behalf Of Anthony Hughes Sent: Monday, 5 May 2008 11:37 AM To: [email protected] Subject: [OzMOSS] Question re limiting data set with stored procedure Hey All, Looking at doing the following for some client solutions. Basically to limit the data set available to a logged in user we are planning to use a stored procedure grabbing parameters from the user's group memberships or parameters stored in the user's account details Wondering if this would even be possible given that user's would be authenticating external via internet using AD account's. IMPORTANT - Please consider our environment before printing this email. This email and any attachments are confidential and may be legally privileged in which case neither is intended to be waived or lost by mistaken delivery to you. If you have received this message in error, please notify us and remove it from your system. If you are not the intended recipient, any unauthorised use is expressly prohibited. It is your responsibility to check any attachments for viruses and defects before opening or sending them on. Minter Ellison collects personal information to provide and market our services. For more information about use, disclosure and access, see our privacy policy at http://www.minterellison.com ------------------------------------------------------------------- OzMOSS.com - to unsubscribe from this list, send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com No virus found in this incoming message. Checked by AVG. Version: 8.0.100 / Virus Database: 269.23.8/1414 - Release Date: 4/05/2008 12:31 PM ------------------------------------------------------------------- OzMOSS.com - to unsubscribe from this list, send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com ------------------------------------------------------------------- OzMOSS.com - to unsubscribe from this list, send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com
