February 4, 2010 at 1:29 pm
what previalges a user need to view standard reports under sql 2005 mgmt studio ?
February 4, 2010 at 7:26 pm
what permissions a user should have to view all of the reorts under Mangement Studio in SQL 2005.
February 4, 2010 at 7:49 pm
Custom reports run by using the permissions of the current user. To prevent a malicious user from changing the queries run by the report, permissions on the file system folder that contains the report files should be set to restrict access.
Both the user and the account that is used by the SQL Server service require read access to the file system folder that contains the report files.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 4, 2010 at 8:05 pm
I am not sure what you are saying but i have a simple question about standard reports.
What permissions need by a user to view standard reports not custom reports.
February 4, 2010 at 8:08 pm
VIEW SERVER STATE permission for server-level and VIEW DATABASE STATE permissions
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 4, 2010 at 8:24 pm
Thanks for that.
is there any risk involved granting that permission to a user?
February 4, 2010 at 8:31 pm
It depends.
I wouldn't grant that kind of permission to anybody outside the database department for any production system. For development, I would consider granting to the development team.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 7 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply