Post reply

Administrating tables in standalone machine

  • July 28, 2008 at 1:08 am

    #126710

    I have developed a database using sql server 2000 and installed on a standalone machine.

    I am using windows authentication.

    Is it possible to prevent other users to see or open this particular database tables via enterprise manager?

    Pl help me in this regard.

    Thanks.

    Kusmanf

  • July 28, 2008 at 1:15 am

    #848972

    Yes, this is always possible. Use SQL Server Security for the same. You can give the access of the database only to the current user. You just need to map the database with the current user.

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

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