Introduction

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. 

Objectives

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.

Permissions: 

• 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.