Hello All
i'm newbie here, was googling and found this site, it looks nice and i think i can learn a lot here,
i have ms sql 2000 with 40 database and static public ip address. i am accessing my server remotly, it started before few weeks, whenever i create any database and login for the database that user can see all other database in server but cant make any changes, it mean it has read rights. i try to do all the things but cant find solution,
here is the things im doing to create new database and login for it.
right click on database -> database name, proper path for data file and log
in logins -> new logins -> new login name, selected sql server authentication and given password for login
in server roles i havent selected anything.
in database access -> i have selected one database and given db_owner rights
but after selecting only one database for new user, still it can see entier database list and admin control panel. how come this possible, any clue ??
thanks in advance