What privileges does the user of the Repository Database need?
updated at
Navicat On-Prem Server will use your user account to create the necessary objects in the repository database. Please make sure that the user account has been granted the proper privileges.
MySQL/MariaDB
SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE TEMPORARY TABLES, CREATE VIEW on all database objects
PostgreSQL
Can login, Can create database and Superuser
SQL Server
CREATE, UPDATE, SELECT and DELETE
Have more questions?
-
Support
-
About Us