Skip to main content

Priviledges

授權分類有以下:​

  • Global Privileges：全域級授權
  • Database Privileges：資料庫級授權(使用db.name.*語法)
  • Table Privileges：表格級授權(使用dbname.tablename語法)
  • Column Privileges：欄位級授權(指定欄位)

使用Workbench管理授權​

  • Administrator > Users and Privileges
  • User為帳號,From Host為可以登入的主機
  • 授權設定：Administrator > Users and Privileges > 選擇User帳號 > 選取Schema Privileges頁籤

使用sql語法管理授權​

################# 查詢授權:
SHOW GRANTS FOR john@localhost;

################# Global授權:
GRANT create,drop ON *.* TO john;
REVOKE create,drop ON *.* FROM john;

################# Database授權:
GRANT create,drop ON dbname.* TO john;
REVOKE create,drop ON dbname.* FROM john;

################# Table授權:
GRANT create,drop ON dbname.tablename TO john;
REVOKE create,drop ON dbname.tablename FROM john;

################# Database授權:
GRANT select(isbn,booknamem,price), update(price) ON book TO john;
REVOKE select(isbn,booknamem,price), update(price) ON book FROM john;