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

Interface for executing SSMS Packages Expand / Collapse
Author
Message
Posted Tuesday, November 25, 2008 10:22 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, June 17, 2009 10:24 AM
Points: 4, Visits: 34
Is there a way to create a quick interface like SSMS to manage SQL tasks for assigning roles?
Post #608850
Posted Tuesday, November 25, 2008 11:40 PM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Friday, March 28, 2014 2:25 PM
Points: 9,902, Visits: 9,479
What would an SSMS Package be?

-- RBarryYoung, (302)375-0451 blog: MovingSQL.com, Twitter: @RBarryYoung
Proactive Performance Solutions, Inc.
"Performance is our middle name."
Post #608869
Posted Tuesday, November 25, 2008 11:52 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, June 17, 2009 10:24 AM
Points: 4, Visits: 34
Let me rephrase the question. I need to create an interface using which a user who does not directly work with SQL Server can create roles, logins, give rights to users etc. I was thinking it will be like simulating SSMS.
Post #608872
Posted Wednesday, November 26, 2008 7:04 AM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Friday, March 28, 2014 2:25 PM
Points: 9,902, Visits: 9,479
Well the functionality is not too hard, you could either use SMO, which is effectively the API for SSMS (actually, it is the management API for SQL Server, which SSMS uses) or you could write a series of stored procedures to give a relatively unprivileged and non-technical user the ability to do this.

What is a lot trickier is the user interface. There are no forms or graphical input capabilities built in to SQL Server (or SSMS), you have to either write client code or just use an existing interface like SSMS. You could just train your user to use the stored procs mentioned above, but this is not very visual.

The alternative would be to write your own GUI using C# or VB.net. It sounds like an interesting project/utility though, something that might be reusable for many other SQL Server customers.


-- RBarryYoung, (302)375-0451 blog: MovingSQL.com, Twitter: @RBarryYoung
Proactive Performance Solutions, Inc.
"Performance is our middle name."
Post #609042
Posted Wednesday, November 26, 2008 7:58 AM


Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: 2 days ago @ 1:45 PM
Points: 770, Visits: 1,178
Mnn, if you assign the users appropriate limited permissions
Won't they just use the same SSMS interface, just with less options?

They don't see everything a sysadmin would see

Beyond that, either write your own GUI or SMO/Power Shell (which I think it's only in SQL 2008)?


SQLServerNewbie

MCITP: Database Administrator SQL Server 2005
Post #609110
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse