Statements are read-only and should only be used to verify your changes:
You can preview the SQL statements generated by Navicat before committing your changes on the SQL Preview tab. Note that columns are added and removed after the Save operation. This configuration removes several admin-related privileges from the table: That will display a list of column names that you may show or hide by checking or unchecking the associated checkbox. However, if you are not interested in some privileges, you can hide them by right-clicking anywhere within the tab and choosing Show/Hide Columns from the context menu. Now our new user has Create, Drop, and Alter privileges on the Sakila database, in addition to Select, Update, Insert, and Delete privileges for the entire server.ĭue the large number of privileges, you'll likely have to scroll horizontally to see some of them. Here's the Privileges tab assigning Create, Drop, and Alter privileges to our user on the Sakila database: 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.
#How to use navicat for mysql how to
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 kommentar(er)
