Post reply

how to provide user level security

  • April 17, 2008 at 1:24 am

    #181535

    hi

    i know to give the system level security by assigning a role but how to give the userlevel security for accessing the report

    thanks in advance

  • April 17, 2008 at 5:25 am

    #803584

    I don't believe there is any such thing as user-level security in SSRS.

    However, if you want to make report data sensitive to a user, then look into using the UserID global variable. The UserID variable may be passed to a stored procedure so that the dataset is populated with data just for the logged on user. Of course, your table data must store the user id.

  • January 28, 2010 at 6:56 am

    #1109954

    Why can't you just add a specific login to a given report's security?

    Steve

    (aka sgmunson)

    :-):-):-)

    patr (4/17/2008)

    hi

    i know to give the system level security by assigning a role but how to give the userlevel security for accessing the report

    thanks in advance

    Steve (aka sgmunson) 🙂 🙂 🙂
    Rent Servers for Income (picks and shovels strategy)

  • February 3, 2010 at 2:30 pm

    #1113215

    you can setup permissions on report through report manager

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

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