Post reply

Limiting access to SQL EM

  • January 30, 2008 at 5:04 am

    #69552

    We have a rather weird requirement to put a third party database on to a SQL server in our DMZ. Is there any way we can give the 3rd party access to Enterprise Manager on that server but only limit them to their own database?

  • January 30, 2008 at 8:52 pm

    #773615

    What i think of is to create a login user for that 3rd party database only (depends upon you what they can/can't access) and when they register the server using their own EM let them use the user you created for that database only as their registration user. That will make them access only their database in their Enterprise Manager

    "-=Still Learning=-"

    Lester Policarpio

  • February 1, 2008 at 12:50 am

    #774075

    Thanks for that - will give it a go

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply