How to make the user orphaned user in 2000

  • 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:

  • 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