Recommended SQL user rights


The following article gives an overview of the database users and their rights and only applies to Amla-managed hosting for both Non-Production and Production DB environments. 


Every SQL Server has a specified DB user and credentials will be shared with you. With these credentials, you will be able to perform the operations listed below.


  • SQL users have the authorization to perform every operation(CRUD)
    • Authorization is given to specific users

    • Server role: Public

  • MSDB database access 
    • Access to create, and delete the SQL jobs.
  • Access to create, and delete the SQL jobs.
    • Create a backup of authorized databases.
      • The backup will be created and saved on the webserver. 

DB Backup & Restore Process: 

  1. Create a ticket and the database team will restore the database and provide all the details in the tickets.
  2. Note: SQL user is not permitted to restore the database in our Server environment. This applies both to the Non-Production and Production DB servers

For reference please see the screenshot below.

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.