469,089 Members | 1,210 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,089 developers. It's quick & easy.

problem with re adding a login

I dropped a login from securities list. and when i try to re add that
login and give the user access to a particular database the error
message
"Error 15023: User or role "user" already exists in the current
database" .
upon enquiry i found out that the PUBLIC role in the databse still
contains that user in its list. I cant seem to remove this user from
the PUBLIC role. and so im not able to readd this user and give him
access to a particular databse... PLease help
Thank You in advance
Jul 20 '05 #1
1 1495
sailesh (sa*****@yahoo.com) writes:
I dropped a login from securities list. and when i try to re add that
login and give the user access to a particular database the error
message
"Error 15023: User or role "user" already exists in the current
database" .
upon enquiry i found out that the PUBLIC role in the databse still
contains that user in its list. I cant seem to remove this user from
the PUBLIC role. and so im not able to readd this user and give him
access to a particular databse... PLease help


Did you try sp_dropuser to get rid of him? sp_change_users_login is another
alternative, which permits you to do it without dropping the user.

--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
Jul 20 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

7 posts views Thread by Dan | last post: by
1 post views Thread by George | last post: by
2 posts views Thread by TIBM | last post: by
4 posts views Thread by Justin | last post: by
2 posts views Thread by Nitin | last post: by
4 posts views Thread by leslie_tighe | last post: by
1 post views Thread by John | last post: by
9 posts views Thread by Dave | last post: by
5 posts views Thread by VictorG | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by kglaser89 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.