Re: Deny Access to Enterprise Manager

From: Hari (hari_prasad_k_at_hotmail.com)
Date: 02/27/04

  • Next message: Hari: "Re: GK - Granting on all objects but not on JOBs ?????" 
    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

  • Next message: Hari: "Re: GK - Granting on all objects but not on JOBs ?????"

    Relevant Pages

    • RMAN Duplicate Question
      ... We are trying to duplicate our production database onto a test server. ...
      (comp.databases.oracle.server)
    • Re: Moving ASP.Net programs to production
      ... My manager> wants everything rewritten in ASP.Net. ... I don't have a clue on how to organize everything so he can> move programs into production easily. ... > After the programs are programmer tested, they are moved to the Users> Test Server. ... > Jim Smith ...
      (microsoft.public.dotnet.framework.aspnet)
    • Re: Backup - Restore
      ... test server from existing production ... ... "Content index restore failed. ... I restored the following databases ...
      (microsoft.public.sharepoint.portalserver)
    • Moving ASP.Net programs to production
      ... I work for a large company that supports many websites. ... find out the best method for putting programs into production. ... Programs are checked out to our Programming Test Server. ... the programs are moved by our Manager to the ...
      (microsoft.public.dotnet.framework.aspnet)
    • Re: Delete Many Rows
      ... Unfortunately the test server that I was given is a much slower machine ... Enterprise Server can parallize a lot of index work so may be faster. ... If I cannot get that window, ... so that production processing can resume. ...
      (comp.databases.ms-sqlserver)