So the user details and group membership are supposed to come from the 3rd party database or from sharepoint?
Look - if you want sharepoint information about a user, you should use the object model to get that data. If you are talking only about getting information for a user from a 3rd party application using the current user's credentials, I suggest you look into the BDC (which may be hard to set up, but then you get some nice features for presentations and security) or develop a web part that accesses the database as the user (which will require Kerberos trust between the sharepoint servers and the 3rd party database - which would be hard if you have an ISA server blocking Kerberos...) or as a system account, passing the user name as a parameter to the stored procedure (no need of Kerberos - but need a system account that can get all users' data) So you see- there are some options of how to do it, but it all depends on what you are actually trying to do, which is still a bit unclear. From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Anthony Hughes Sent: Monday, 5 May 2008 2:58 PM To: [email protected] Subject: RE: [OzMOSS] RE: Question re limiting data set with stored procedure 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]<mailto:[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 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
