Dropping user

[Parasu]

Hi all,
I'm unable to drop a user. I used
exec sp_dropuser 'user1'
It says that the user doesnt exist in the database.
In the EM, i checked for the user in the Security - Logins. His name is there, but he hasnt been assigned any database. But, his default database is master.
So, i checked in the sysusers of the master, but, his username is not there.
How to knock off this guy?

Thanx
Parasuraman Parasuraman

 

[rajeevnandanmishra]

Hi Parasuraman,

in SQL user and login means different.
I think u had created a login name.
And to drop it use
sp_droplogin myLoginToDrop
give the login name without quotes i.e. if login name is james then issue the command :
sp_droplogin james

 

[Parasu]

Hi rajeev,
Thanx alot. I'll try that. Does this login been created in the NT? What is the difference between the two.
Thanx again
Parasu
Parasuraman

 

[tlbroadbent]

Check SQL BOL for explanation of login and user.

Basically, the login provides access to the server and each login can be granted access to databases as a user. NT logins can be granted access to SQL Server (NT Authentication). Or you can create separate SQL Server logins (SQL Authentication).
Terry Broadbent
Please review faq183-874.

"The greatest obstacle to discovery is not ignorance -- it is the illusion of knowledge." - Daniel J Boorstin