I shows each registered database for a connection, along with a list of privileges, listed in each row. Want to assign privileges for a specific database? The Privileges tab is the place to do that. Rather than select individual checkboxes, you can also grant and revoke all listed privileges at once by right-clicking anywhere on the Server Privileges tab and choosing the appropriate option from the context menu: For example, the following configuration assigns Select, Update, Insert, and Delete privileges to our new user for the entire server: To assign a privilege, simply check the option against the server privilege listed. This tab contains a list of privileges that apply to the server connection as a whole. In today's blog, we'll move on to the remaining tabs of the New User Object tab: namely, Server Privileges, Privileges, and SQL Preview. Part 2 focussed on setting a new user's account details, account limits, and SSL settings. In Part 1, we learned how to secure the MySQL root account using the Navicat Premium User Management Tool. In this series, we've been exploring how to perform common user administration tasks using Navicat's flagship product, Navicat Premium. By Robert Gravelle Part 3: Configuring User Privileges
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |