Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

SSRS Browser role.

Posted on 2010-09-22
9
Medium Priority
?
587 Views
Last Modified: 2012-05-10
I am setting up the security for SSRS.

For a user who will only need to see report reports should I only assign them to the 'Browser' role.
0
Comment
Question by:Mr_Shaw
  • 5
  • 4
9 Comments
 
LVL 29

Accepted Solution

by:
QPR earned 2000 total points
ID: 33732805
spot on, that is exactly what the role is created for
0
 

Author Comment

by:Mr_Shaw
ID: 33732986
I have a user setup with the 'Browser' role and their System Role Assignments is set to 'System User'.

They still however can see the 'Data Sources' folder.

Is there a way in which I we can stop them seeing this folder?
0
 
LVL 29

Assisted Solution

by:QPR
QPR earned 2000 total points
ID: 33733006
go to the properties of the DS and make it hidden
0
NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

 
LVL 29

Assisted Solution

by:QPR
QPR earned 2000 total points
ID: 33733016
sorry that should be the datasource folder
0
 

Author Comment

by:Mr_Shaw
ID: 33733060
I now becomes hidden for everyone including me. How do I unhide it or have it hidden for some users and visable for others?
0
 
LVL 29

Assisted Solution

by:QPR
QPR earned 2000 total points
ID: 33733203
for you, just click the show details icon in the folder. for others it is hidden. This is how it works
0
 

Author Comment

by:Mr_Shaw
ID: 33733394
That does work. But when I click show details using an account with just the 'Browser' role I can still see the 'Data Sources' folder.
0
 
LVL 29

Assisted Solution

by:QPR
QPR earned 2000 total points
ID: 33738435
have you tried having a separate folder for the datasources and then putting security on that?
0
 

Author Closing Comment

by:Mr_Shaw
ID: 33770564
thanks
0

Featured Post

Restore individual SQL databases with ease

Veeam Explorer for Microsoft SQL Server delivers an easy-to-use, wizard-driven interface for restoring your databases from a backup. No expert SQL background required. Web interface provides a complete view of all available SQL databases to simplify the recovery of lost database

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.
Suggested Courses

578 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