sezemiadmin · December 26, 2018 02:25
diff --git a/grant.sql b/grant.sql
 grant [権限名]
  on [スキーマ名].[テーブル名]
  to [ユーザ名]
diff --git a/insert.sql b/insert.sql
 mysql> insert into SAMPLE01
    -> VALUES (111, "X", "2018-10-18");
 Query OK, 1 row affected (0.02 sec)
diff --git a/insert_error.sql b/insert_error.sql
 mysql> insert into SAMPLE01
    -> VALUES (111, "X", "2018-10-18");
 ERROR 1142 (42000): INSERT command denied to user 'myuser260'@'localhost' for table 'SAMPLE01'
diff --git a/show.sql b/show.sql
 mysql> show databases;
 +--------------------+
 | Database           |
 +--------------------+
 | SEP1019            |
 | SEPLUS             |
 | information_schema |
 +--------------------+
 3 rows in set (0.01 sec)
	mysql> insert into SAMPLE01
	-> VALUES (111, "X", "2018-10-18");
	ERROR 1142 (42000): INSERT command denied to user 'myuser260'@'localhost' for table 'SAMPLE01'