new user login Problem

  • I have installed SQL 2000 on my local system. Now i have added a new user login with no server roles and have only access to pubs database as Public but i noticed that new user can access all other databases and can drop and create tables. Notice i have by default WINDOWS BUILTIN/administrator login. How can i restrict this new user to only pubs database?

  • Not sure this is the right forum for SQL 2000 but anyone with adminstrative rights in Windows will have admin rights in SQL Server 2000/2005 by default. You can remove builtin/administrators but make sure you have another user or group in there with sysadmin rights before you do it. SQL Server 2008 doesn't add the builtin/administrators group by default.

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

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