Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Logins and Users

Author  Topic 

DNF98
Starting Member

12 Posts

Posted - 2008-03-13 : 08:37:55
Hi. I have a couple of questions relating to Logins & Users.

If I have a Login with 0 Server Roles assigned, and 0 Database Access -- is it safe to say this login is not used and can be deleted?

If I have a User that is not connected to a login (and it is not a mapping issue) -- is it safe to say the user can be deleted?

Lookout, I'm in cleanup mode!

Thanks in advance!

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-03-13 : 23:22:34
1. yes.
2. yes.
Go to Top of Page

DNF98
Starting Member

12 Posts

Posted - 2008-03-14 : 09:31:30
Thank you!
Go to Top of Page
   

- Advertisement -