|
Home > Archive > microsoft.public.cert.mcdba > January 2004 > SECURING MS SQL ENTERPRISE MANAGER
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
SECURING MS SQL ENTERPRISE MANAGER
|
|
| ESSIEN 2004-01-16, 12:26 pm |
| I want somebody out there to tell me how to restrict
users access to Microsoft SQL Server Enterprise Manager
to only the Database Administrator.
Would be more than glad if someone could help out. Thanks.
Best Regards,
Essien - MCAD
| |
| Ray Higdon 2004-01-16, 3:25 pm |
| What is your current situation? You are asking a specific question, do
people besides the DBA have the SA password? Do you use mixed mode or
windows authentication? Have you already removed the built-in admins group
or any other domain admins account?
--
Ray Higdon MCSE, MCDBA, CCNA
--
"ESSIEN" <anonymous@discussions.microsoft.com> wrote in message
news:001101c3dc4b$f68cb3e0$a30
1280a@phx.gbl...
> I want somebody out there to tell me how to restrict
> users access to Microsoft SQL Server Enterprise Manager
> to only the Database Administrator.
>
> Would be more than glad if someone could help out. Thanks.
>
> Best Regards,
> Essien - MCAD
| |
| Kael V. Dowdy 2004-01-17, 1:24 am |
| "Ray Higdon" <sqlhigdon@nospam.yahoo.com> wrote in message news:<e$28jYG3DHA.3256@tk2msftngp13.phx.gbl>...
> What is your current situation? You are asking a specific question, do
> people besides the DBA have the SA password? Do you use mixed mode or
> windows authentication? Have you already removed the built-in admins group
> or any other domain admins account?
>
> --
> Ray Higdon MCSE, MCDBA, CCNA
> --
It's funny sometimes, ppl will post a question like that and provide
you little or no detail about their actual problem or their
environment.
It's like you picking up the phone and someone asks, "Do you know the
way to San Jose?"
But...the person didn't tell you where they are, or how they want to
get there. Are they in Los Angeles? Maybe they're in Florida...or
maybe in Russia. Do they want to drive, take a bus, or fly?
Depending on these answers, your response would be different
obviously. You wouldn't tell them to take I-64 West if they were in
Russia. Same thing applies here.
Someone posting a response to a question wouldn't have the time or
gumption to come up with 50 different scenarios to "try" to answer
what he "thinks" your actual problem might be...it could be as long as
a thesis paper, when all the person wanted to do was delete the
Enterprise Manger icon from the user's desktop.
Just my 2 cents.
Kael
[color=blue]
> "ESSIEN" <anonymous@discussions.microsoft.com> wrote in message
> news:001101c3dc4b$f68cb3e0$a30
1280a@phx.gbl...
| |
| simzzs 2004-01-22, 5:24 am |
| hi,
what we can do is suppose the machine p400 is the on
which you do not want 2 give any 1 access to the
Enterprise Manager, you can delete all the sql server
registerations on it when not needed. and 'sa' shld have a
password.
now imagine a case when i am admin (sa), i have deleted
all sql server registerations on p400, if other user comes
on this machine, he / she cannot do any activity as they
might not have the 'sa' admin password.
i hope this helps
>-----Original Message-----
>"Ray Higdon" <sqlhigdon@nospam.yahoo.com> wrote in
message news:<e$28jYG3DHA.3256@tk2msftngp13.phx.gbl>...
specific question, do[color=blue]
mixed mode or[color=blue]
built-in admins group[color=blue]
>
>It's funny sometimes, ppl will post a question like that
and provide
>you little or no detail about their actual problem or
their
>environment.
>
>It's like you picking up the phone and someone asks, "Do
you know the
>way to San Jose?"
>
>But...the person didn't tell you where they are, or how
they want to
>get there. Are they in Los Angeles? Maybe they're in
Florida...or
>maybe in Russia. Do they want to drive, take a bus, or
fly?
>Depending on these answers, your response would be
different
>obviously. You wouldn't tell them to take I-64 West if
they were in
>Russia. Same thing applies here.
>
>Someone posting a response to a question wouldn't have
the time or
>gumption to come up with 50 different scenarios to "try"
to answer
>what he "thinks" your actual problem might be...it could
be as long as
>a thesis paper, when all the person wanted to do was
delete the
>Enterprise Manger icon from the user's desktop.
>
>Just my 2 cents.
>
>Kael
>
message[color=blue]
Manager[color=blue]
Thanks.[color=blue]
>.
>
|
|
|
|
|