万里数据库GreatDB集中式数据库运维之用户权限管理-3

权限管理

授予权限

GRANT
    priv_type [(column_list)]
      [, priv_type [(column_list)]] ...
    ON [object_type] priv_level
    TO user_or_role [, user_or_role] ...
    [WITH GRANT OPTION]
    [AS user
        [WITH ROLE
            DEFAULT
          | NONE
          | ALL
          | ALL EXCEPT role [, role ] ...
          | role [, role ] ...
        ]
    ]
}

给用户greatdb@localhost授予所有权限：

GRANT ALL ON *.* TO 'greatdb'@'localhost';

给用户greatdb@%授予db1的所有权限：

GRANT ALL ON db1.* TO 'greatdb'@'%';

给用户greatdb@192.168.1.130授予表db1.table1的所有权限：

GRANT ALL ON db1.table1 TO 'greatdb'@'192.168.1.130';