Post reply

Data security in SSRS 2008 report based on Active Directory

  • May 5, 2011 at 2:46 am

    #236922

    Hi,

    I have a requirement to control the data displayed in the report (SSRS 2008) based on the user logging in.

    Eg: If the sales data is being shown in the report,the user should see the data for which he has access.

    The security, which user has access to which region's data, is defined in the active directory.

    There are different groups for each region and users having access to the data are made members of the appropriate group.

    How do I connect to the Active directory from the report so that i can know which group the user belongs to?

    Any help in this regard is much appreciated.

    Thanks,

    Ninu

  • May 5, 2011 at 10:31 pm

    #1320779

    ninu (5/5/2011)

    How do I connect to the Active directory from the report so that i can know which group the user belongs to?

    Any help in this regard is much appreciated.

    My recommendation is to contol the data returned at the back end (SQL Server level).

    Create SQL Server Logins for the Active Directory Group/User. Create View to filter the data based on the Login. Grant select permision to View.

  • May 6, 2011 at 4:50 am

    #1320892

    Go to particular column and then RIGHT CLICK and then click on Expression

    =IIF(user(),Fields!Sales.Value,'NA')

    you can do this with IIF condition ,you can visit on this link for global parameters in SSRS

    http://msdn.microsoft.com/en-us/library/ms157274(v=sql.90).aspx

    Regards,
    Syed Jahanzaib Bin Hassan
    BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA

    My Blog
    www.aureus-salah.com

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply