SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


A Report to Display and Edit User 'Rights'


A Report to Display and Edit User 'Rights'

Author
Message
Jon Spink
Jon Spink
SSC Eights!
SSC Eights! (804 reputation)SSC Eights! (804 reputation)SSC Eights! (804 reputation)SSC Eights! (804 reputation)SSC Eights! (804 reputation)SSC Eights! (804 reputation)SSC Eights! (804 reputation)SSC Eights! (804 reputation)

Group: General Forum Members
Points: 804 Visits: 945
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/gwilson/areporttodisplayandedituserrights.asp
kenno_rules
kenno_rules
SSC-Enthusiastic
SSC-Enthusiastic (152 reputation)SSC-Enthusiastic (152 reputation)SSC-Enthusiastic (152 reputation)SSC-Enthusiastic (152 reputation)SSC-Enthusiastic (152 reputation)SSC-Enthusiastic (152 reputation)SSC-Enthusiastic (152 reputation)SSC-Enthusiastic (152 reputation)

Group: General Forum Members
Points: 152 Visits: 173

Hi,

I don't have a lot to say about this, except that I think this idea is brilliant in its simplicity. I've been using Reporting Services for about 2 years now, and I would never have thought of this (maybe I'm just dumb??). As a DW developer, I'm often asked for seemingly simple things like - "how can our admin user trigger a month-end process to start once we're happy with the source data". I give them various options, all of which are usually pretty poor, eg how about 'right-click, start job' in enterprise manager? I guess this is because I have virtually no App Dev skills, and can't just put together a nice little webpage or desktop app. I suppose I can now have a report with a list of admin tasks (sql agent jobs) which are all hyperlinks which will go away and sp_StartJob the job when clicked. Handy!

Matt.





abates100
abates100
SSC-Enthusiastic
SSC-Enthusiastic (144 reputation)SSC-Enthusiastic (144 reputation)SSC-Enthusiastic (144 reputation)SSC-Enthusiastic (144 reputation)SSC-Enthusiastic (144 reputation)SSC-Enthusiastic (144 reputation)SSC-Enthusiastic (144 reputation)SSC-Enthusiastic (144 reputation)

Group: General Forum Members
Points: 144 Visits: 51

Wonderful! In meeting just yesterday expressing the same type requirements for a DR tracking application. I also have been using RS and now SSRS since it came out. We are very interested in editing via a report because there is so much functionality built in RS that our developers sometimes have difficulty providing via the web app.

Could you provide and example of the hyperlink code/expression that calls the sproc again and the sproc itself? Can't quite get my brain around it. But then it's awful early!

AB





Antares686
Antares686
SSCoach
SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)

Group: Moderators
Points: 15174 Visits: 785
I think this is exceptional. My biggest concern with something like this however is you have to be sure you have your security nailed. Since the hyperlink is a set of querystring commands you open the potentials a lot for someone to alter without recourse. Verify you secuirty model to be sure nothing unexpected happens and hire someone to do an ethical hack to see if this has any potential loopholes. As you are using RS in a non-standard way you can be sure MS will not cover you if someone get's in where they should not be.



Don Becker
Don Becker
SSC-Enthusiastic
SSC-Enthusiastic (109 reputation)SSC-Enthusiastic (109 reputation)SSC-Enthusiastic (109 reputation)SSC-Enthusiastic (109 reputation)SSC-Enthusiastic (109 reputation)SSC-Enthusiastic (109 reputation)SSC-Enthusiastic (109 reputation)SSC-Enthusiastic (109 reputation)

Group: General Forum Members
Points: 109 Visits: 22

Reporting = R

Applications = CRUD


Stephanie J Brown
Stephanie J Brown
SSC Eights!
SSC Eights! (994 reputation)SSC Eights! (994 reputation)SSC Eights! (994 reputation)SSC Eights! (994 reputation)SSC Eights! (994 reputation)SSC Eights! (994 reputation)SSC Eights! (994 reputation)SSC Eights! (994 reputation)

Group: General Forum Members
Points: 994 Visits: 1103
On the surface, this looks like a wonderful feature - so long as Microsoft doesn't close a loophole or something. I can think of several ways we could use this for the projects I work on; and it could increase the users productivity. I can also see it getting very out-of-hand, and having users request processes that really should not fit in a reporting session. Could be a double-edged sword.


Here there be dragons...,

Steph Brown
cliffb
cliffb
SSC Eights!
SSC Eights! (935 reputation)SSC Eights! (935 reputation)SSC Eights! (935 reputation)SSC Eights! (935 reputation)SSC Eights! (935 reputation)SSC Eights! (935 reputation)SSC Eights! (935 reputation)SSC Eights! (935 reputation)

Group: General Forum Members
Points: 935 Visits: 438

I have to agree that Reporting should be reads. Applications should be CRUD. But then you have the argument, Reporting Services is an Application. =)

This could work with limited exposure (such as working through a checklist) but could also be dangerous if someone tries to make this thier data management tool.

Good Article, Clever solution.

For anything more than just marking a field status or flipping a bit on or off, I would recommend using the .NET 2.0 and ASP.NET 2.0. They have made some nice improvements for data interaction.





Andy Warren
Andy Warren
SSCoach
SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)

Group: Moderators
Points: 15245 Visits: 2730

Im going to go against the grain and say that I don't really care for the solution (though I appreciate what you were trying to accomplish). In general I dont think reports should modify base data. One alternative thats easy enough to manage without code would be linking the table into an Access mdb.



Andy
SQLAndy - My Blog!
Connect with me on LinkedIn
Follow me on Twitter
YSLGuru
YSLGuru
SSCrazy
SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)

Group: General Forum Members
Points: 2430 Visits: 1665

Is there anyway you could share the reporting solution source files with teh rest of us who are curious as to how you did this? The article is great in showing that this can be done with RS but lacking in how it's done and a good article shoudl do both



Kindest Regards,

Just say No to Facebook!
Don Becker
Don Becker
SSC-Enthusiastic
SSC-Enthusiastic (109 reputation)SSC-Enthusiastic (109 reputation)SSC-Enthusiastic (109 reputation)SSC-Enthusiastic (109 reputation)SSC-Enthusiastic (109 reputation)SSC-Enthusiastic (109 reputation)SSC-Enthusiastic (109 reputation)SSC-Enthusiastic (109 reputation)

Group: General Forum Members
Points: 109 Visits: 22
Was the article pulled?
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search