Re: Disable EM ?
From: news.microsoft.com (deo.is_at_unknown.com)
Date: 07/19/04
- Next message: Narayana Vyas Kondreddi: "Re: tool to generate test data"
- Previous message: Euan Garden[MS]: "Re: IWD4 -- SQL Management Studio server name issue"
- In reply to: TVO: "Re: Disable EM ?"
- Next in thread: Steve Thompson: "Re: Disable EM ?"
- Reply: Steve Thompson: "Re: Disable EM ?"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 19 Jul 2004 16:01:31 -0700
Change the security settings for ...\Microsoft SQL Server\80\Tools\BinnSQL
Server Enterprise Manager.MSC
or delete it.
"TVO" <anonymous@discussions.microsoft.com> wrote in message
news:00a001c46dc8$654f2930$a301280a@phx.gbl...
> I have permissions applied through AD Groups and SELECT
> only rights are applied. However the locking semantics
> of EM are different than that of QA. I want to disable
> their ablilty to launch or use EM and yet still allow
> them to query via written code using QA. Any ideas?
>
> Thanks
>
>
> >-----Original Message-----
> >"TVO" <anonymous@discussions.microsoft.com> wrote in
> message
> >news:002801c46dc0$53377bb0$a301280a@phx.gbl...
> >> Is is possible to disable Enterprise Manager and still
> >> retain query analyzer functionality??
> >
> >You can use security to effectively prevent a user from
> mis-using Enterprise
> >Manager.
> >
> >> If yes then how??
> >
> >The most secure solution would only allow read or
> execute permissions on
> >designated views, or stored procedures.
> >
> >Steve
> >
> >
> >.
> >
- Next message: Narayana Vyas Kondreddi: "Re: tool to generate test data"
- Previous message: Euan Garden[MS]: "Re: IWD4 -- SQL Management Studio server name issue"
- In reply to: TVO: "Re: Disable EM ?"
- Next in thread: Steve Thompson: "Re: Disable EM ?"
- Reply: Steve Thompson: "Re: Disable EM ?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
