EM Deny Registration

How can one deny registration of a particular SQL Server
through Enterprise Manager and still be able to open a
query analyzer and access the target database of that
particular server (read only)? My problem is some users
had a green light from above to have an Enterprise
Manager installed on their server but yet have very
little experience navigating it. I am afraid if they
registered this particular server and accidentally open a
table (all rows). I can not deny them access completely
since they need to have read access from the database.Hi,
You cant restrict EM alone. If the user have access then they will be able
to register in EM.
Thanks
Hari
SQL Server MVP
"LD" <anonymous@.discussions.microsoft.com> wrote in message
news:082201c5406f$a7440ed0$a401280a@.phx.gbl...
> How can one deny registration of a particular SQL Server
> through Enterprise Manager and still be able to open a
> query analyzer and access the target database of that
> particular server (read only)? My problem is some users
> had a green light from above to have an Enterprise
> Manager installed on their server but yet have very
> little experience navigating it. I am afraid if they
> registered this particular server and accidentally open a
> table (all rows). I can not deny them access completely
> since they need to have read access from the database.
>|||LD
You can restict permissions to do any operations per database. Let me say if
the user has not permissions to operate with a database XXX ,so he will not
be able to get in vs EM.
"LD" <anonymous@.discussions.microsoft.com> wrote in message
news:082201c5406f$a7440ed0$a401280a@.phx.gbl...
> How can one deny registration of a particular SQL Server
> through Enterprise Manager and still be able to open a
> query analyzer and access the target database of that
> particular server (read only)? My problem is some users
> had a green light from above to have an Enterprise
> Manager installed on their server but yet have very
> little experience navigating it. I am afraid if they
> registered this particular server and accidentally open a
> table (all rows). I can not deny them access completely
> since they need to have read access from the database.
>