how to drop user - SQL Server Forums

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

General SQL Server Forums

New to SQL Server Programming

how to drop user

Author

Topic

tphong7
Starting Member

1 Post

Posted - 2011-12-02 : 16:44:23

i tried to drop a login user from a database. it gives me a error (cannot drop the user, because it does not exist or you do not have permission)

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-12-03 : 00:17:21

the credential you're using to connect to db doesnot have drop login permission which is why it gives above error. Ask your admin to give you this permission using GRANT statement if you want to do this.

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

sandy123
Starting Member

14 Posts

Posted - 2011-12-04 : 09:37:43

for droping a login requires ALTER ANY LOGIN permission on the server
and you can check your permission by below query
USE DBname;
SELECT *
FROM fn_my_permissions(NULL, 'SERVER');
GO

sandy

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources