One of the more frequent requests that a SQL Server DBA receives is to “Clone a login” with all its permissions. For example a request could be
– Clone BILL_BLACK’s login and create a new login JACK_JOHNSON with exactly the same privileges in all databases.
– Clone AD group login BILLING_APP_ADMINS and create a login for new AD group BILLING_APP_CONSULTANTS with the same permissions as BILLING_APP_ADMINS in all databases
Read on to see how.