Jump toUpdate content

How to manage user permissions for Managed Database for PostgreSQL and MySQL

Reviewed on 13 June 2023 • Published on 25 March 2022

Permissions define the actions a user can perform on a logical database. A database user is generated automatically when you create your Database Instance and this user is attributed all permissions. However, newly created users have no permissions by default.

Security & Identity (IAM):

You may need certain IAM permissions to carry out some actions described on this page. This means:

  • you are the Owner of the Scaleway Organization in which the actions will be carried out, or
  • you are an IAM user of the Organization, with a policy granting you the necessary permission sets
Requirements:

Set permissions for an existing user

  1. Click PostgreSQL and MySQL under Managed Databases on the side menu. A list of your Database Instances displays.

  2. Click the database name or «See more Icon» > More info to access the Database Instance information page.

  3. Go to the Users tab. A list of users displays.

  4. Click «See more Icon» > Update permissions to open the user permissions panel.

  5. Select the appropriate permissions for each database.

    Note:

    Three types of permissions are available:

    • None: No access to the database
    • Read: Allow users to read tables and fields in a database
    • Write: Allow users to write content in databases
  6. Click Update user to confirm.

Set permissions for a new user

During user creation, the permissions panel can be accessed through the top tab menu. For more information see how to add users.

Note:

Permissions are applied on existing items at the moment the configuration is set, and not applied to any items created afterward. When you modify your Database configuration, your configured permissions are automatically set to Custom. The Custom setting ensures that your permissions are still valid for items created before you reconfigured your Database. Any items created after you change your configuration will not have permissions applied to them, you must set new permissions.

See Also