Delegate Privileges Setup for dave on FinanceDB

Last update on October 18 2025 12:17:36 (UTC/GMT +8 hours)

Grant All Privileges with GRANT OPTION

Write a MySQL query to grant all privileges on the "FinanceDB" database to the user "dave" along with the ability to grant privileges to others.

Solution:

-- This command gives the user 'dave' full control over the FinanceDB database
-- Grants all privileges on all tables in FinanceDB for localhost connections
-- Includes WITH GRANT OPTION, allowing 'dave' to grant privileges to others
GRANT ALL PRIVILEGES ON FinanceDB.* TO 'dave'@'localhost' WITH GRANT OPTION;

Explanation:

Purpose of the Query:

The goal is to allow the user "dave" full control over FinanceDB and enable him to delegate privileges.
This demonstrates the use of WITH GRANT OPTION in privilege assignment.

Key Components:

GRANT ALL PRIVILEGES : Assigns all possible privileges.
WITH GRANT OPTION : Permits the user to grant the same privileges to others.

Real-World Application:

Useful for administrative accounts that manage user permissions.

Notes:

Use WITH GRANT OPTION judiciously, as it can lead to excessive privilege distribution.

For more Practice: Solve these Related Problems:

Write a MySQL query to grant all privileges on the "FinanceDB" database to the user "dave" with the GRANT OPTION and restrict access to tables starting with "fin_".
Write a MySQL query to grant all privileges on "FinanceDB" to "dave" with GRANT OPTION and then immediately verify the privileges using SHOW GRANTS.
Write a MySQL query to grant all privileges on "FinanceDB" to "dave" with GRANT OPTION and set an expiration time for the granted privileges.
Write a MySQL query to grant all privileges with GRANT OPTION on "FinanceDB" to "dave" and then simulate a privilege delegation by granting privileges to another user.

Go to:

PREV : Grant Read-Only Privileges.
NEXT : Create a User with Host Restriction.

Have another way to solve this solution? Contribute your code (and comments) through Disqus.