Post reply

Orphaned logins

  • December 12, 2014 at 3:53 am

    #299412

    Hi,

    I have a SQL 2012 database which I have backed up and restored on a separate instance of SQL 2012. The database itself has users that are mapped to logins (AD group) that don't exist on the new server however users are still getting full privileges to the new database.

    If I delete the user from the database on the new server (which I believed to be orphaned), the users privileges cease.

    How is this possible?

    Note: the database is not using containment.

    Thanks

    Andrew

  • December 12, 2014 at 4:34 am

    #1764345

    Could the users in the restored database get their assiciated login through other AD-groups defined as LOGIN? Check the membership of the accounts in AD with the groups defined in the SQL instance.

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply