Part 4: The Privilege Manager tool
In this series, we've been exploring how to perform common user administration tasks using Navicat's flagship product, Navicat Premium. In the last blog, we looked at the Server Privileges, Privileges, and SQL Preview tabs of the New User Object tab.
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. Available for MySQL, Oracle, PostgreSQL, SQL Server and MariaDB, the Privilege Manager will be the subject of today's blog.
Part 3: Configuring User Privileges
In this series, we've been exploring how to perform common user administration tasks using Navicat's flagship product, Navicat Premium. In Part 1, we learned how to secure the MySQL root account using the Navicat Premium User Management Tool. Part 2 focussed on setting a new user's account details, account limits, and SSL settings. 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: Creating a New User
In Part 1, we learned how to secure the MySQL root account using the Navicat Premium User Management Tool. Today's blog will focus on setting a new user's account details, account limits, and SSL settings.
Part 1: Securing the Root Account
Managing the users of a database is one of the key responsibilities of the database administrator (DBA). Coordinating how users in your organization access your database typically entails many separate tasks, from adding new users, blocking access to users who have left the organization, and helping users who cannot log in.
The Virtual Group feature provides a mechanism for logical grouping of the Navigation Pane's database objects by category, so that all objects are more effectively organized. It can be applied to many different object types, including:
- 2024 (1)
- 2023 (1)
- 2022 (1)
- 2021 (1)
- 2020 (1)
- 2019 (1)
- 2018 (1)
- 2017 (1)
