Report Credentials

Hi i have created serveral reports in sql and uploaded it to report manager. We have an issue here. We have 5 departments at our place.

Each of the department has 5 reports. We want the department for instance Administration to open/view only their reports and no others. How is this done

"Credentials supplied by the user running the report"

Basically if i give sa and sa as username and password, i will be able to enter any department reports but i want something like sa say 'admin' this user will only open his reports and no one else.

there is also security for the folder. I could clump all the reports instead of type do it by department. So all admin reports in one folder and only admin should have access and no one else say if there is another user manager he cant access it.

Do you have any idea on how to go abt this situation?

Sheldon

Hey anyone can help me please?|||

Hi,

Each of the department has 5 reports. We want the department for instance Administration to open/view only their reports and no others

From your description, it seems that you want to grant different permission against the your users from different department, right?

In your post, you have mentioned such accounts like 'sa', I think this is the account which is for accessing the database. But in your case, we don't need to care the database security layer. What you need is to use Administrator account to logon your report site, and create different repot folders for different departments. After that, Just as you said, go into the folder and open the property tab, click on "security", here, you can grant the permission to specific users for the current folder.

there is also security for the folder. I could clump all the reports instead of type do it by department. So all admin reports in one folder and only admin should have access and no one else say if there is another user manager he cant access it.

For this part, I'm not quite sure if I've misunderstood your words. Do you mean you have multiple users with administrator permissions? If so, there's no way to prevent him from accessing folders on this report site.

Thanks.

|||

Okay All Reports Divided Into Departments

How to create a user for each department so that the user will access only their repective folder.

Dont know how to do this

|||

Hi,

You can open your IE and visit your report site, go into site settings, and conifig the site's security, create a new role assign, type the name, select the corresponding role, and submit your action.

Thanks.