SitePoint Sponsor

User Tag List

Results 1 to 1 of 1

Threaded View

  1. #1
    SitePoint Member
    Join Date
    Jan 2005
    Location
    NZ
    Posts
    9
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    WITH GRANT OPTION grants nothing.

    It stands to reason that you cannot grant privileges without access to the privileges table.

    I've created a user to be in charge of a specific database only.
    It has GRANT OPTION (@ both 'localhost' and '%').

    But it cannot grant anything:
    ERROR 1044: Access denied for user: 'novice@localhost' to database 'mysql'
    Translation: "Oh, you have forgotten to repeat the meaning of WITH GRANT OPTION explicitly".

    Surely not. Those extra privileges would then be grantable to others.

    But what does WITH GRANT OPTION grant if it all of its functionality has to be specified with other privileges?

    Surely something else is wrong, but SHOW GRANTS looks fine, and the user can use its other privileges as intended.

    What is the least amount of extra privilege that must be granted for GRANT OPTION to work?
    Last edited by zol; Feb 6, 2005 at 00:08.


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •