使用超级 dbauser root,创建一个 user_admin 用户,该用户具备超级用户的权限,即全部的权限。
1) 创建user_admin用户。
gbase> CREATE USER user_admin;
Query OK, 0 rows affected
gbase> SET PASSWORD FOR user_admin = PASSWORD('H%897_@m');
Query OK, 0 rows affected
2) 对于 user_admin 用户赋予全部权限。
gbase> GRANT ALL ON *.* TO user_admin;
Query OK, 0 rows affected
3) 使用 user_admin 用户登录数据库,验证其具备全部权限。
gbase> USE test;
Query OK, 0 rows affected
gbase> SELECT * FROM t1;
+------+
| a |
+------+
| 1 |
| 2 |
| 3 |
| 4 |
| 5 |
| 6 |
| 7 |
| 8 |
| 9 |
| 10|
+------+
10 rows in set
gbase> UPDATE t1 SET a = 11 WHERE a = 10;
Query OK, 1 row affected
gbase> SELECT * FROM t1;
+------+
| a |
+------+
| 1 |
| 2 |
| 3 |
| 4 |
| 5 |
| 6 |
| 7 |
| 8 |
| 9 |
| 11|
+------+
10 rows in set
gbase> DELETE FROM t1 WHERE a >= 5;
Query OK, 6 rows affected
gbase> SELECT * FROM t1;
+------+
| a |
+------+
| 1 |
| 2 |
| 3 |
| 4 |
+------+
4 rows in set




