Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

A Report to Display and Edit User 'Rights' Expand / Collapse
Author
Message
Posted Monday, July 24, 2006 4:19 PM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Wednesday, June 20, 2012 5:02 AM
Points: 530, Visits: 945
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/gwilson/areporttodisplayandedituserrights.asp
Post #296914
Posted Wednesday, August 09, 2006 2:55 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, March 06, 2014 12:39 AM
Points: 113, Visits: 151

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.




Post #300500
Posted Wednesday, August 09, 2006 6:09 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, April 09, 2009 8:30 AM
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




Post #300542
Posted Wednesday, August 09, 2006 7:40 AM
SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: Moderators
Last Login: 2 days ago @ 3:54 PM
Points: 8,369, Visits: 733
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.


Post #300586
Posted Wednesday, August 09, 2006 10:14 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, September 24, 2010 5:17 PM
Points: 49, Visits: 22

Reporting = R

Applications = CRUD 

Post #300658
Posted Thursday, August 10, 2006 10:28 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Yesterday @ 10:28 AM
Points: 583, Visits: 931
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
Post #300963
Posted Friday, August 11, 2006 6:43 AM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Tuesday, October 22, 2013 11:18 AM
Points: 676, Visits: 432

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.




Post #301165
Posted Saturday, August 12, 2006 8:28 PM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: Moderators
Last Login: Yesterday @ 9:01 AM
Points: 6,705, Visits: 1,680

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
Post #301395
Posted Thursday, August 24, 2006 3:34 PM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Monday, March 10, 2014 1:21 PM
Points: 885, Visits: 1,526

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,

A Democracy works great until the day you find yourself on the sheep side of a vote between 5 wolves and 4 sheep on what’s for dinner when neither have eaten in many days. A free Republic where the rights of the few and the individual are protected is the only one in which Freedom and Prosperity for all have a chance to blossom.
Post #303978
Posted Thursday, August 24, 2006 4:02 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, September 24, 2010 5:17 PM
Points: 49, Visits: 22
Was the article pulled?
Post #303987
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse