Results 1 to 1 of 1
  1. #1
    Join Date
    Nov 2003
    Location
    Am Ende der Welt
    Posts
    12

    Post Unanswered: Drop login and associated users/aliasses

    Dropping a login also requires to drop previously all users and aliasses mapping the login in the different databases where that login has access. This can be a tediuos task for dataservers that concentrate a huge number of databases and account administration is an important matter. In particular, when you have to migrate logins to a new server, it shoud be easy to drop the logins from the source server as they are no longer used.

    The script attached helps you to drop the specified login from the server, by searching a user or alias mapping in every database and dropping it first before the login can be finally dropped.

    I hope this helps.

    César Buzzo
    Senior Database Administrator
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •