新建用户

create user username identified by userpassword;

修改用户

alter user ziling identified by 123456;

授与用户dba权限
grant dba to ziling;

解除用户dba权限
Revoke dba from ziling;

查询用户权限
select * from user_role_privs;
查看所有用户
select * from dba_users;

查看所有权限
select * from dba_profiles;

查看所有角色
select * from dba_roles;

创建角色,经角色授与权限,并授给用户

create role role_read;
grant select any table to role_read;
create user user_read identified by user_read;
grant role_read to user_read;

ITPub博客

用户操作相关命令