How to manage user permissions for Serverless SQL Databases

Permissions define the actions a user or an application can perform on a database. They are managed using Scaleway’s Identity and Access Management interface.

Before you start

To complete the actions presented below, you must have:

• A Scaleway account logged into the console
• Owner status or IAM permissions allowing you to perform actions in the intended Organization

1. Click Identity and Access Management (IAM) from the top-right of your Organization Dashboard in the Scaleway console. The Users tab of the Identity and Access Management dashboard displays.

2. Click the Policies tab. A list of the Organization’s existing policies displays.

3. Click Create a policy. The policy creation wizard displays.

4. Complete the steps on the first page of the creation wizard:

• Enter a name for the policy.

• Enter a description (optional).

• Select a principal, who will be the target of your policy. The principal should be the user, application, or group you want to grant access to your database.

5. Click Add rules. The second screen of the policy creation wizard.

6. Select Access to resources, then, select the Project in which you want the permissions to apply.

7. Click Validate to continue.

8. Select Serverless in the left-hand Products list, then, tick the permissions set you want to add to the policy:

• ServerlessSQLDatabaseFullAccess allows the user to create and delete databases, edit their configuration, and use the following commands:

  • SELECT
  • UPDATE
  • INSERT
  • DELETE
  • CREATE/ALTER/DROP TABLE
  • CREATE/DROP INDEX

• ServerlessSQLDatabaseReadWrite allows the user to use the following commands:

  • SELECT
  • UPDATE
  • INSERT
  • DELETE
  • CREATE/ALTER/DROP TABLE
  • CREATE/DROP INDEX

• ServerlessSQLDatabaseReadOnly allows the user to use the following commands:

  • SELECT

9. Click Validate. The scope and the permission sets of your policy display.

10. Click Create policy to finish.