在我们使用MySQL数据库的过程中，经常会遇到MySQL授权表，下面就为您举例说明MySQL授权表的用法，供您参考学习之用。MySQL授权表使用举例grant用于给增加用户和创建权限，revoke用于删除用户权限。 下面是一些用grant增加用户和创建权限的例子：mysql> grant all privileges on *.*&
create用户
create user visiontv identified by visiontv default tablespace visiontv quota 10m on users;
grant privilege
grant connect,resource to visiontv;
create tablespac
db2 "grant usage on workload sysdefaultuserworkload to user appmon"db2 "grant all on table <tabname> to user appmon"db2 "grant execute on package NULLID.SQLUAO20 to appmon"db2 "gra...
授权某个权限给某个角色：GRANT DELETE ANY TABLE TO "UCITROLE"; 将DELETE ANY TABLE 权限授权给UCITROLE角色权限：ALTER ANY INDEX ALTER ANY TABLE ALTER ANY TRIGGER CREATE ANY INDEX CREATE ANY JOB CREATE ANY SEQUENCE CREATE ANY TABLE CREATE ANY TRIGGER CREATE ANY VIEW CREATE SEQUENCE CREATE SESSION DELETE ANY TABLE DR
