Post reply

How to restrict databases in Enterprise manager?

  • September 23, 2003 at 7:50 am

    #106508

    Is there any way to list only database that belongs to a particular user while connecting thru Enterprise manager instead of showing all databases which normally it display ??

  • September 24, 2003 at 5:53 am

    #475562

    With SQL Server 2000, you could create an instance for just this one database.

    Why is a user in EM? Perhaps you could whip up a utility using DMO instead of allowing users access to EM.

    --Jonathan



    --Jonathan

  • September 24, 2003 at 7:20 am

    #475582

    quote:

    Suppose client wants to connect to a server using his EM by registering the server with his userid which has only access to one database in the server, he should only see that database rather than all DB in that server. Can we restrict this some how?

    --Tiwary

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

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