SharePoint - personal views on lists and libraries - What happens when a user is deleted

Posted on 2011-05-12
Last Modified: 2012-05-11

What happens to the personal views a user has created for x libraries and lists when that account is deleted from the SharePoint (meaning the user has no more access to any apps, sites or subsites) or AD?  In which DB and table is that information stored?  Is there a process that needs to be, or can be, run that makes sure that all of these views are removed when the user is removed as well?

Question by:relliott66
    LVL 7

    Accepted Solution

    any contents ,views , pages create by user will reamain there even if he leaves the company . after you remove him from AD , he will not have access to them . but his name will be there in your farm . you can search on his name and it will show you  contents created by him.
    There are 3rd party toold that do this job much better by the way ,

    personal views are stored  in content data base . to see the personal views
    go to SQL go to the content data base
    run this query on the table dbo.webparts
    select tp_viewfrom webparts
    where tp_displayname like '%reliott66%'
    LVL 7

    Author Comment

    k, so even if I remove the user from the farm by deleting from Sharepoint (every site, library, list, etc) that user's 'personalizations' will still remain as an artifact in the DBs?

    And thanks for the query.  Found that one this morning as well :)  But, since the post only showed you were to look I left this question open....
    LVL 7

    Author Closing Comment


    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    I have just recently built a new SharePoint 2007 farm on a complete Windows 2008 R2 server platform and part of my standard build procedure is to implement a warm up routine, usually in the form of a script that is scheduled every morning to launch …
    Pimping Sharepoint 2007 without Server-Side Code Part 1 One of my biggest frustrations with Sharepoint 2007 in the corporate world is that while good-intentioned managers lock down the more interesting capabilities of Sharepoint programming in…
    Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
    Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

    729 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now