How to add users to a Serverless SQL Database

Users and applications can connect to a database and access its data. Each one can have a different set of customizable permissions.

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
• Created a Serverless SQL Database
• Created a policy to manage users’ permissions
• Invited a user to your Organization or created an application in IAM

How to add a user to a Serverless SQL Database

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 email of the user you want to give database access to.

3. Open the Groups & Policies tab.

4. Click + Attach a policy. The policy attachment wizard displays.

5. Choose Select an unassigned policy, then, select the previously created policy from the drop-down menu.

   Note

   You can also create a new policy or duplicate an existing one to manage the permissions of a user.

6. Click Validate.

How to add an application to a Serverless SQL Database

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. Open the Applications tab.

3. Click the name of the application you want to give database access to.

4. Click the Groups & Policies tab.

5. Click + Attach a policy. The policy attachment wizard displays.

6. Choose Select an unassigned policy, then, select the previously created policy from the drop-down menu.

   Note

   You can also create a new policy or duplicate an existing one to manage the permissions of an application.

7. Click Validate.