Re: Deny Access to Enterprise Manager
From: Hari (hari_prasad_k_at_hotmail.com)
Date: 02/27/04
- Previous message: Gary: "Deny Access to Enterprise Manager"
- In reply to: Gary: "Deny Access to Enterprise Manager"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Fri, 27 Feb 2004 15:33:36 +0530
Hi,
Just look into the Application roles in BOL. In the test server you can
create a diffrent user with database owner previlage. This will allow the
users to access enterprise manager in test server.
Thanks
Hari
MCDBA
"Gary" <garyt0dd@hotmail.com> wrote in message
news:c178b834.0402270120.319e6ce1@posting.google.com...
> I have 2 Sql servers, one is production and one is test both set up
> with mixed mode due to application requirments. User need access to
> the test server through Enterprise Manager, but they can also register
> the production server. How can I stop them accessing the production
> server through Enterprise Manager wbut still authenticate to it
> through the application??
>
> Regards.
>
> Gary
- Previous message: Gary: "Deny Access to Enterprise Manager"
- In reply to: Gary: "Deny Access to Enterprise Manager"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
