Home Forums SQL Server 7,2000 Security Limit Access to Databases in Enterprise Manager RE: Limit Access to Databases in Enterprise Manager

  • If the Server in the enterprise manager in the users computer is registered using the user "sa" then he can access all the databases even restricting him since the server in his EM is registered with sys admin rights. You can unregister the server in his EM, register it again using the user account you've made (not sa) then he can only view the database were his username has access to.

    "-=Still Learning=-"

    Lester Policarpio