Click here to monitor SSC
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
Mr or Mrs. 500
Mr or Mrs. 500 (530 reputation)Mr or Mrs. 500 (530 reputation)Mr or Mrs. 500 (530 reputation)Mr or Mrs. 500 (530 reputation)Mr or Mrs. 500 (530 reputation)Mr or Mrs. 500 (530 reputation)Mr or Mrs. 500 (530 reputation)Mr or Mrs. 500 (530 reputation)

Group: General Forum Members
Points: 530 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 (122 reputation)SSC-Enthusiastic (122 reputation)SSC-Enthusiastic (122 reputation)SSC-Enthusiastic (122 reputation)SSC-Enthusiastic (122 reputation)SSC-Enthusiastic (122 reputation)SSC-Enthusiastic (122 reputation)SSC-Enthusiastic (122 reputation)

Group: General Forum Members
Points: 122 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 (140 reputation)SSC-Enthusiastic (140 reputation)SSC-Enthusiastic (140 reputation)SSC-Enthusiastic (140 reputation)SSC-Enthusiastic (140 reputation)SSC-Enthusiastic (140 reputation)SSC-Enthusiastic (140 reputation)SSC-Enthusiastic (140 reputation)

Group: General Forum Members
Points: 140 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
SSCrazy Eights
SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)

Group: Moderators
Points: 8426 Visits: 780
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 Rookie
SSC Rookie (49 reputation)SSC Rookie (49 reputation)SSC Rookie (49 reputation)SSC Rookie (49 reputation)SSC Rookie (49 reputation)SSC Rookie (49 reputation)SSC Rookie (49 reputation)SSC Rookie (49 reputation)

Group: General Forum Members
Points: 49 Visits: 22

Reporting = R

Applications = CRUD


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

Group: General Forum Members
Points: 808 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
Say Hey Kid
Say Hey Kid (681 reputation)Say Hey Kid (681 reputation)Say Hey Kid (681 reputation)Say Hey Kid (681 reputation)Say Hey Kid (681 reputation)Say Hey Kid (681 reputation)Say Hey Kid (681 reputation)Say Hey Kid (681 reputation)

Group: General Forum Members
Points: 681 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
SSCertifiable
SSCertifiable (7.2K reputation)SSCertifiable (7.2K reputation)SSCertifiable (7.2K reputation)SSCertifiable (7.2K reputation)SSCertifiable (7.2K reputation)SSCertifiable (7.2K reputation)SSCertifiable (7.2K reputation)SSCertifiable (7.2K reputation)

Group: Moderators
Points: 7233 Visits: 2679

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
SSC Eights!
SSC Eights! (959 reputation)SSC Eights! (959 reputation)SSC Eights! (959 reputation)SSC Eights! (959 reputation)SSC Eights! (959 reputation)SSC Eights! (959 reputation)SSC Eights! (959 reputation)SSC Eights! (959 reputation)

Group: General Forum Members
Points: 959 Visits: 1659

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 Rookie
SSC Rookie (49 reputation)SSC Rookie (49 reputation)SSC Rookie (49 reputation)SSC Rookie (49 reputation)SSC Rookie (49 reputation)SSC Rookie (49 reputation)SSC Rookie (49 reputation)SSC Rookie (49 reputation)

Group: General Forum Members
Points: 49 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