September 11, 2008 at 10:05 am
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?
September 16, 2008 at 2:51 am
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 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy