Oracle 创建用户并赋予权限

create user {用户名} identified by {密码};
grant connect,resource to {用户名};
grant unlimited tablespace to {用户名};

create user student identified by 123456;
grant connect,resource to student;
grant unlimited tablespace to student;

grant dba to {用户名} 可以授予管理员权限，一般不用。

补充：

查询用户角色：select * from user_role_privs;

撤销用户角色：revoke {角色} from {用户名};

revoke dba from workflow;

查询用户权限：select * from user_sys_privs;