Showing posts with label content. Show all posts
Showing posts with label content. Show all posts

Monday, March 12, 2012

Permissions can't see the contents or properties tabs on the HOME

I have installed RS in development with no problems, but after installing on
a production server, I can not see the Content tab on the home page and can
not create folders. DBA's are not allowed to be administrators on
production servers. I went into site settings and created a new role
assignment making myself a systems administrator in report services but still
cannot see the content tab.Did you solve this ? I have the same issue and have been battling for
days!!!
"Andy998" <Andy998@.discussions.microsoft.com> wrote in message
news:8F4AC6DF-4AA1-4BBD-9AA3-C1C6078BAFEC@.microsoft.com...
> I have installed RS in development with no problems, but after installing
on
> a production server, I can not see the Content tab on the home page and
can
> not create folders. DBA's are not allowed to be administrators on
> production servers. I went into site settings and created a new role
> assignment making myself a systems administrator in report services but
still
> cannot see the content tab.

Saturday, February 25, 2012

permission problem

In sql server 2005, what is minimum right a user need to view the content of stored-procedures? That is, in SSMS the user will be able to right click a stored-procedure and then select "Modify" to view the content, but the user has no permission to promote it?


Thanks!

I don't understand what you mean by promote because there is no promote permission but most of what you need is covered in this thread below. Hope this helps.

http://forums.asp.net/thread/1492092.aspx

|||

I want to allow the users to able to view the content of stored-procedure, but they are not allowed to modify or create stored-procedures. What permission should I give to the user? It is easy in sql server 2000, but 2005 seems has different implementation. Thanks.

|||That is db_datareader permission but that is in the database your user also need the server login because there are two permissions in SQL Server, the server and the database. So go back to that thread for how to create it. Hope this helps.