1.创建用户以及设置密码:
create user username identified by password;
2.设置用户登录权限(connect、resource):
grant connect to username;
3.修改用户密码:
alter user user1 identified by 234556;
4.删除用户:
drop user user1;
5.开通用户对其他用户表的操作权限:
grant select,update,delete,insert on UserTagPool to [app_webservice];