EM Deny Registration

From: LD (anonymous_at_discussions.microsoft.com)
Date: 04/13/05 

Date: Wed, 13 Apr 2005 14:27:54 -0700

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.

Relevant Pages

  • Re: sql server 2000 tools
    ... First you need to register production server with your username and password ... You don't need to access *.ldf files ... Then you should do a Transaction Log backup from Enterprise Manager. ...
    (microsoft.public.sqlserver.tools)
  • Re: Linked Server (Oracle 9i)
    ... >enterprise manager registration properties if you are using sa or windows ... >> Microsoft ODBC for Oracle ... >> When I try to connect to the linked server in Enterprise Manager I get ...
    (microsoft.public.sqlserver.odbc)
  • Re: Linked Server (Oracle 9i)
    ... >enterprise manager registration properties if you are using sa or windows ... >> Microsoft ODBC for Oracle ... >> When I try to connect to the linked server in Enterprise Manager I get ...
    (microsoft.public.sqlserver)
  • Re: SA can not create users
    ... I also thought it may be enterprise manager but if I register different ... server on same enterprise manager I am able to create users for that new ... Simon Hayes wrote: ... >client tools completely. ...
    (comp.databases.ms-sqlserver)
  • Re: Processadmin problems
    ... Enterprise Manager was written a little earlier than some of the function ... > our server as well as by support personnel for the application. ... > This login had been a member of the sysadmin fixed server role but I ...
    (microsoft.public.sqlserver.security)