oracle创建用户并授权命令

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];