RS in the object explorer

Question

RS in the object explorer

db042188

SSC Eights!

Points: 819
More actions
April 10, 2009 at 10:25 am

#132687

our temporary dba and I were looking at RS on one server and couldnt see how he could give me permission to see it in object explorer from my own desktop (ie thru security or roles tabs like we see in the engine and AS). It happens to be rs2008 but I hope the answer is the same.
Does anyone know what steps he would take to do this?

Viewing 6 posts - 1 through 5 (of 5 total)

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

Lowell SSC Guru Points: 323518 More actions · Answer 1

i think you are after this command, which allows you to see structure of tables(but not hte data), as well as the text of procs and views, right?

GRANT VIEW DEFINITION ON MyProc TO SomeUser

or

GRANT VIEW DEFINITION ON Schema myuserschema TO SomeUser

or GRANT VIEW DEFINITION ANY TO SomeUser

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

db042188 SSC Eights! Points: 819 More actions · Answer 2

thanks Lowell, that is possible, I'm more familiar with the db engine and AS instances so I'm not sure what would happen if we right clicked an RS object and tried to run a query like the ones you recommended under a connection to RS. We'll give it a whirl and let you know.

db042188 SSC Eights! Points: 819 More actions · Answer 3

nope, its really wierd, there is a security tab hanging off the RS instance, but with only roles and system roles, no apparent way to set them.

The roles are the same "publisher" etc roles that you assign to specific users under Report Manager (the web interface), and I think we set those correctly the other day for my userid. But now that I think about it, wouldnt you think we'd see my userid's roles if we were in the right object, we didnt see anything specific to any user in mgt studio.

The system roles (eg system admin) for the RS instance we were looking at didnt appear to be settable in mgt studio. Maybe it is these that allow you to view RS objects.

we right clicked the RS instance and didnt see any way to run a query.

I may need to wait till our dba returns, I just learned that she fought some of these battles with RS in the past.

db042188 SSC Eights! Points: 819 More actions · Answer 4

I'm not sure but it looks like what I was after is a database called ReportServer right on the DB Engine instance.

It contains a number of tables that at first glance contain anything and everything you'd want to know about Reports, including subscription properties, something I'm investigating right now.

It is mixed right in with all of our other databases in Mgt Studio's Object Explorer.:blush:

db042188 SSC Eights! Points: 819 More actions · Answer 5

I'm also a little interested in snapshots and snapshot history. I cant for the life of me see where RS keeps the actual data, but I'll leave that for another post.