How to crawl SQL DBs while maintaining access rights? RRS feed

  • 问题

  • Hi,

    I have N tables (of differing structures) in a SQL2008 DB, all of which need to be indexed. For each table, I have a distinct set of AD users (named e.g. CONTOSO\BLOGGS; CONTOSO\SMITH etc.) who can search through that table i.e. the set of authorised users is different for each table.

    How can I structure the DB such that all tables are indexed while ensuring that CONTOSO\BLOGGS can only see records from the tables that CONTOSO\BLOGGS is authorised to see, preferably without having to write any code?



    2011年6月23日 10:52


  • Are you sure that you are asking a SharePoint questions?

    SharePoint cannot crawl SQL Server database directly, but it can be crawled as BDC, it may involve codes.

    With BDC and rules, you can crawl different tables under different credentials.

    Lambert Qin [秦磊] | 博客(Blog): SharePoint in My Eyes 中文 / LinkedIn
    Posting is provided "AS IS" with no warranties, and confers no rights.
    2011年6月27日 7:30