title: Automating the permissions of login/users in sql server to another Login/user by Stored Procedure
body: <p>Automating the Process of Duplicating permissions from login/user to another Login/user by Stored Procedure or some automated process</p>
  
  <p>Test Cases:</p>
  
  <pre><code>Create Login2/user like Login1/user for all databases 
  Create Login2/user like Login1/user for single database
  Mirror Login2/user like Login1/user for all databases 
  Mirror Login2/user like Login1/user for single database
  Augment Login2/user permissions from Login1/user for all databases
  Augment Login2/user permissions from Login1/user for single database
  </code></pre>