How to give permission to User to Grant permissions to Other Users in MySQL Server - MySQL DBA Tutorial

How to use With Grant Option in MySQL Server


If you want the user to grant privileges to other users in MySQL Server, you can use WITH GRANT OPTION. The user will be only able to GRANT the permissions he/she has.

Syntax:

MySQL > GRANT Permission ON Object/s to 'USER'@'Host' WITH GRANT OPTION;

Example : 
Let's say that if we are providing SELECT permission to TB USER on TechBrothers Database. We want to provide permission to TB so he can provide SELECT permission to other user if want. When we will be providing SELECT permission to TB, we will use WITH GRANT OPTION.


MySQL > GRANT Select ON TechBrothers.* to 'TB'@'localhost' WITH GRANT OPTION;

MySQL tutorial for beginners - How to use With GRANT OPTION in MySQL Server to provide privileges to User

9 comments:

  1. Hi User
    If you are game lover then you can visit our site.APK JADE

    ReplyDelete
  2. If we are facing this kind of problem while playing Outdoor Basketball that doesn’t mean that we don’t have good Basketball shoe manufacturers. We do have some best quality Outdoor Basketball shoe options. In this article, we have compiled a list of the Best shoe options. All the mentioned shoes have been tested for their crucial features such as material, designs, and adhesion.
    best outdoor basketball shoes

    ReplyDelete