March 4, 2004 at 11:31 am
I created login and gave restricted rights (dbreader) to user for development database. The user with restricted rights can click on the server and he has the options to Stop or Pause the server. How can I deny the access to this options?
Is it possible do not show to users with restricted rights the option ‘Stop’ server from Enterprise Manager?
March 4, 2004 at 11:55 am
Unless they have the admi rights, this will produce an error. Unfortuneately EM is an admin tool, not a developer tool. I'd take this away from the developesr. QA has an object browser, which should be all they need.
March 5, 2004 at 3:28 am
I am thinking of granting a user access to EM so they can use DTS to generate ad hoc queries and copy data to access/excel. DTS was the recommendation beacause the user (who is reponsible and reaonably knowledgable) used to use ms query on 6.5 and also because it is free. Ideally I would like to limit the user to pre-defined packages I have created.
My question is - Am I mad???
March 8, 2004 at 9:56 am
You're not mad. You can't do this (unfortunately). Until DTS is a serparate MMC snap in, they will have all the tools.
March 8, 2004 at 10:40 pm
You could achieve this by using dtsrunui.exe that ships with client tools. User has to do a logon, retrieve list of dts available, fill in parameters and execute package.
I think, This utility will server almost all of your above stated needs.
And you can issue a "deny insert on msdb..sysdtspackages" for that login, then that person would not be able to save new packages in SQL server.
March 9, 2004 at 2:29 am
Amit you're a genius!
That sounds the business. Thank you very much.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply