Database Permissions Required for Liferay

Issue

• Could you please provide us with a list of Database Permissions required for Liferay to function? (We are optimizing our application security concerning the Database)

Environment

• Liferay DXP 7.1
• Liferay DXP 7.2
• Liferay DXP 7.3
• Liferay DXP 7.4

Resolution

• Liferay requires reading from and writing to the database. Therefore, the Liferay database user must have permission to read and write data.
• Additionally, when setting up Liferay for the first time, it is always recommended to grant full rights for the Liferay DXP database user to do anything to the database (full database permissions).

Additional Information

• However, if your organization has more stringent security policies that require limiting Liferay DXP database user permissions once the database is initialized, please go through the following official article that might give you more insights on this:
  
  • High-Security Database User Practices