Scroll the grid horizontally until reaching the Trigger privilege checkbox.Click the Sakila Database in the Object tree.To assign Trigger privileges to on the Sakila Database: That being said, if you do, Navicat will ask you if you'd like to save your changes when you close the Privilege Manager tab.Ĭlicking a Database name displays a list of users that have access to it, along with their respective privileges. Don't forget to click the Save button on the Privilege Manager toolbar to commit your changes. For example, clicking the Trigger checkbox in the row will grant Trigger privileges that that user:Ĭonversely, unchecking the box for a privilege removes that privilege. Check the box beside the privilege to assign it to that user.Scroll the grid horizontally until reaching the target privilege that you're interested in.If it is not already selected, click the Connection name to see a list of users that have access, along with their respective privileges.The Connection always appears at the top of the tree, with databases below it, along with individual objects within each: Let's start with Connection-level privileges. That will open the Privilege Manager in a new tab with the connections for the most recently opened connection.įrom there, you can either work with Connection-level privileges or those associated with a particular database. To access the Privilege Manager, click the Privilege Manager button on the User Object toolbar. Available for MySQL, Oracle, PostgreSQL, SQL Server and MariaDB, the Privilege Manager will be the subject of today's blog. Setting privileges for each user as we did in the last blog is not the only way to do so the Privilege Manager offers another way to set privileges for a connection as well as its database objects. In the last blog, we looked at the Server Privileges, Privileges, and SQL Preview tabs of the New User Object tab. 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 4: The Privilege Manager tool
0 Comments
Leave a Reply. |