How to Modify Database User Privileges in Plesk Panel?

 
In this article, we'll explain how we can modify MySQL/MariaDB database user privileges in the Plesk Panel.
 
The privileges assigned to a database user determine the specific actions they are allowed to perform within the database. These actions might involve querying data, modifying tables, or even managing the entire database structure. By adjusting these privileges, administrators can control access levels and ensure the security and integrity of their databases.
 

Kindly follow the steps mentioned below to Modify Database User Privileges in the Plesk Panel.

 
Step 1: Log in to your Plesk Control Panel.
 
Step 2: Click on the Databases Icon.
 
 
Step 3: Click on the User Management.
 
 

A list of database users will be displayed.

 
Step 4: Click on the database user's name to modify its privileges.
 
 
Step 5: Scroll down the page and find the Privileges section, categorized into Data Access and Structure Access.
 
Here, you'll find a list of privileges assigned to the user, including options such as SELECT, INSERT, UPDATE, DELETE, and more.
 
To modify these privileges, just check or uncheck the boxes next to the corresponding checkboxes to grant or remove access as required.
 
 

The role acts as templates that help to assign permissions to a database user. Below are the database user roles:

 
  • 1. Read and Write.
  • 2. Read Only
  • 3. Write Only
  • 4. Custom(corresponds to a user-defined set of privileges)
Each role has a predefined set of privileges granted to a database user account with that role. You can edit the sets of privileges corresponding to different roles.
 

Data Access

 
Select: Retrieves data from a database.
Insert: Adds new records into a table.
Update: Modifies existing records in a table.
Delete: Removes records from a table.
 

Structure Access

 
  • Create: Creates new database objects like tables, indexes, views, or procedures.
  • Drop: Deletes existing database objects.
  • References: Establishes a foreign key relationship between tables.
  • Alter: Modifies the structure of an existing database object like a table or index.
  • Index: Creates an index on a table.
  • Create Temporary Tables: Creates temporary tables.
  • Lock Tables: Locks tables to prevent concurrent access and maintain data integrity.
  • Create View: Creates a virtual table based on the result set of a SELECT query.
  • Show View: Displays the definition of a view.
  • Create Routine: Creates stored procedures or functions.
  • Alter Routine: Modifies the definition of existing stored procedures or functions.
  • Execute: Executes a prepared statement or stored procedure.
  • Event: Schedules tasks to run at specified times.
  • Trigger: Executes a set of SQL statements in response to certain actions on a table, such as inserts, updates, or deletes.
Step 6: Select the desired privileges for the user and click the OK button at the bottom of the page.
 
 
You will receive a success message like below once user privileges are updated.
Information: The database user's acutest account was successfully updated.
That's all. You can refer to the steps mentioned in this article to update/modify the database User privileges in the Plesk Panel.
You can submit a ticket or initiate a chat from our website if you experience any issues with modifying the user privilege.
 

Was this answer helpful?

« Back

chat