PrinterOn KB Powered By ePRINTit USA

How to create an SQL user and assign DB owner permission - c06355663

  1. Once connected to your DB using Microsoft SQL Server Management Studio, expand Security and Logins
  2. Right click on Logins and create a new User, choose SQL Server authentication and set a password.
  3. Once the user is created right click on the user name and select properties
  4. Select User Mapping from the left hand menu
  5. Check all the databases you want to grant DB owner permission on the left menu.
  6. Once checked check DB_Owner on the bottom.