How to manage user permissions for Managed Database for PostgreSQL and MySQL
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.
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
- A PostgreSQL or MySQL Database Instance
Set permissions for an existing user
-
Click PostgreSQL and MySQL under Databases on the side menu. A list of your Database Instances displays.
-
Select the geographical region of the Instance you want to manage from the drop-down.
-
Click the database name or more icon > More info to access the Database Instance information page.
-
Go to the Users tab. A list of users displays.
-
Click more icon > Update permissions to open the user permissions panel.
-
Select the appropriate permissions for each database.
-
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.