Results 1 to 6 of 6

Sharepoint List Query Filter based upon User Login

  1. #1
    Steven.Allman is offline Advanced Beginner
    Windows Vista Access 2007
    Join Date
    Feb 2010
    Posts
    67

    Sharepoint List Query Filter based upon User Login

    Very nice complex database recently uploaded to Sharepoint so I am using linked tables. I want to distribute this for wider availability, but due to sensitivity issues, I do not want "Bill" to have access to view "Jim" and vice versa.
    Our Sharepoint automatically logs users in via a digital Common Access Card.
    So when they open up the frontend database, their CAC login would give them permissions to the sharepoint linked tables, and the forms and reports would be queried based upon BILL or JIM..
    Not sure if that makes sense..
    I could recreate the entire database for each person who needs it, changing queries for each one, but when I make one change to MY copy of the database, I would have to go in and import to each subsequent, then update the query again, etc..
    Is this more a Sharepoint issue?

  2. #2
    June7's Avatar
    June7 is online now Moderator
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    30,547
    Security management of data can be an issue with any project, not just Sharepoint delivered data. So yes, use filter by userID on data. This requires at least one table have a field with userID and table would be joined to other tables on pk/fk relationships to make the userID field available for filter criteria.
    To provide db: Make copy, remove confidential data, run compact & repair, zip if large - 2mb allowed, attach to post. Attachment Manager is below the Advanced post editor window.
    If suggestion in this post resolves your issue, please use the Thread Tools and mark the thread as Solved!

    Debug!Debug!Debug! http://www.cpearson.com/excel/debug.htm

  3. #3
    Steven.Allman is offline Advanced Beginner
    Windows Vista Access 2007
    Join Date
    Feb 2010
    Posts
    67
    Well part of the issue is my authority for the "User Information List" table is view only, and I work for the largest corporation in the world, the US Military... So should I create a seperate table where I have copied the user data for the few people I want, and then create a field in that table that gives record 1 permissions to "JIM" for "GROUP1" and record 2, "Bill" permissions for Group2?
    Once I did this, I see where my forms have the ability to FILTER and FILTER ON LOAD, but I have tried a few things with some Querys and its not cooperating with me..
    This seems very complex, and perhaps beyond my capabilites.
    This forum has done wonders for me thus far, however...

  4. #4
    June7's Avatar
    June7 is online now Moderator
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    30,547
    What is 'Group1' and 'Group2'? Is there a field in other tables that has these values as attribute to each record?

    Do you want to provde project for analysis? Make copy, remove confidential data, run Compact & Repair, zip if large, attach to post or upload to fileshare site such as box.com and post link. I just helped a Marine with a question after he provided db.
    To provide db: Make copy, remove confidential data, run compact & repair, zip if large - 2mb allowed, attach to post. Attachment Manager is below the Advanced post editor window.
    If suggestion in this post resolves your issue, please use the Thread Tools and mark the thread as Solved!

    Debug!Debug!Debug! http://www.cpearson.com/excel/debug.htm

  5. #5
    Steven.Allman is offline Advanced Beginner
    Windows Vista Access 2007
    Join Date
    Feb 2010
    Posts
    67
    June7, I ran into a bigger issue.
    I thought everything was working great, up until I tried to delete a record from Table1, using form 1. I have a JOIN between my tables, and when my backend was ACCESS, the Unit Identification Code was a primary key for Unit Information, and for personnel it was the SSN.
    If I was adding billy, then his SSN 123-12-1234 and when I went to put his UIC in table1, it would use my join to look for that UIC in table2(unti information) and populate several other fields in my forms, and thereby my reports. Great...
    Sharepoint lists aparently must have an autonumber PK, which means my forms would create "Recordset not updateable" unless I did Dynaset inconsistent updates.
    Then when I went to delete a person(record from table1) the other day, I also deleted the UNIT from table2.
    This cannot happen.
    How can i force sharepoint to allow my UIC field and my SSN field be the PK, so that I may change my form attributes back to Dynaset, and everything be happy!!!

  6. #6
    June7's Avatar
    June7 is online now Moderator
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    30,547
    Sorry, I don't have experience with Sharepoint.
    To provide db: Make copy, remove confidential data, run compact & repair, zip if large - 2mb allowed, attach to post. Attachment Manager is below the Advanced post editor window.
    If suggestion in this post resolves your issue, please use the Thread Tools and mark the thread as Solved!

    Debug!Debug!Debug! http://www.cpearson.com/excel/debug.htm

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 10
    Last Post: 03-02-2012, 09:06 AM
  2. display a list of values based on user input
    By karl1971 in forum Access
    Replies: 3
    Last Post: 12-06-2011, 07:19 AM
  3. Query for user to filter by every field
    By tommy93 in forum Queries
    Replies: 7
    Last Post: 11-07-2011, 02:14 AM
  4. Replies: 3
    Last Post: 09-22-2011, 02:35 PM
  5. Replies: 1
    Last Post: 03-01-2009, 07:53 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Tech Forums: Microsoft Office Forums