August 19, 2009 at 12:43 pm
Hi Guys,
here is my problem, business user want me to remove the logins without removing the database users. Meaning, to make some database users orphaned. He want to remove the logins without removing the access of that login to the database? is there a way? Thanks.
:-):cool:
August 19, 2009 at 12:53 pm
do it through query analyser using sp_droplogin store procedure. that will leave user in the database but the login will be removed so that ID will have no access to SQL server and will not be able to access any databases, so not sure why you want to do this.
PS - I'd rather you did not scan my computer for software I am running.
edit: you cannot remove a login whilst still maintaining access to a database - this request does not make sense.
---------------------------------------------------------------------
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy