August 7, 2003 at 10:26 am
If I allow a user to use the SQL enterprise manager in his workstation but only want him to execute a DTS package, how can I do this so that user can't do anything else such as stopping the MSSQL service and other deadly features that the user may accidentaly select. The user login doesn't belong to any default role and is simple SQL login belonging to the Public group.
Any help is very much apprecated.
August 7, 2003 at 11:56 pm
Hi Wingman,
quote:
If I allow a user to use the SQL enterprise manager in his workstation but only want him to execute a DTS package, how can I do this so that user can't do anything else such as stopping the MSSQL service and other deadly features that the user may accidentaly select. The user login doesn't belong to any default role and is simple SQL login belonging to the Public group.
I'm not sure, if you run into licensing issues, by 'just' installing another instances of EM.
Anyway, why do you want to do this?
What about using the dtsrun utility?
You could create a nice batch file for this user to accomplish this task.
dtsrun is explained in BOL.
HTH
Cheers,
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply