Shulou(Shulou.com)06/01 Report--

This article is about how navicat manages remote permissions. The editor thought it was very practical, so I shared it with you as a reference. Let's follow the editor and have a look.

Use Navicat to connect to the local server (if previously connected, please open the connection)

Click menu bar-> user

Click New user

Advanced: you can set the maximum number of queries / updates / connections / connections and SSL per hour for this user.

Server permissions: set operation permissions for all databases on the server.

Permissions: set permissions for specific libraries and tables. When there is a conflict with the server permission setting, the server permission shall prevail.

SQL Preview: the SQL statements for all of the above settings are displayed here.

Server permission description

Thank you for reading! On the navicat management of remote permissions to share here, I hope that the above content can be of some help to you, so that you can learn more knowledge. If you think the article is good, you can share it and let more people see it.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.