Skip to content
Snippets Groups Projects
  • Oliver Salzburg's avatar
    392a4dd6
    Use specific privileges when creating admin · 392a4dd6
    Oliver Salzburg authored
    
    Using the ALL shorthand can cause problems when not all privileges are available to the user.
    For example, AWS RDS MariaDB/MySQL will not grant the initial user account on an instance the SUPER privilege.
    While the user account is still valid for pretty much any task on the DB instance, it can not use the ALL shorthand when granting privileges to new users.
    By supplying a specific set of privileges, we work around this limitation without sacrificing functionality.
    
    Closes #16139
    
    Signed-off-by: default avatarOliver Salzburg <oliver.salzburg@gmail.com>
    Use specific privileges when creating admin
    Oliver Salzburg authored
    
    Using the ALL shorthand can cause problems when not all privileges are available to the user.
    For example, AWS RDS MariaDB/MySQL will not grant the initial user account on an instance the SUPER privilege.
    While the user account is still valid for pretty much any task on the DB instance, it can not use the ALL shorthand when granting privileges to new users.
    By supplying a specific set of privileges, we work around this limitation without sacrificing functionality.
    
    Closes #16139
    
    Signed-off-by: default avatarOliver Salzburg <oliver.salzburg@gmail.com>