创建一个用户user3,口令为user3,默认表空间为USERS,在该表空间的配额为10MB。
CREATE USER user3 IDENTIFIED BY user3 DEFAULT TABLESPACE USERS QUOTA 10M ON USERS;
为用户user3授予CREATE SESSION、CREATE TABLE、CREATE VIEW系统权限。
GRANT CREATE SESSION,CREATE TABLE,CREATE VIEW TO user3;
创建一个用户user4,口令为user4,默认表空间为USER,在该表空间的配额为10MB,概要文件为默认。
CREATE USER user4 IDENTIFIED BY user4 DEFAULT TABLESPACE USERS TEMPORARY TABLESPACE TEMP QUOTA 10M ON USERS;
为用户user4授予CREATE SESSION、CREATE TABLE、CREATE INDEX系统权限。user4获得权限后,为用户user3授予CREATE INDEX系统权限。
GRANT CREATE SESSION,CREATE TABLE,CREATE ANY INDEX TO user4 WITH ADMIN OPTION;
grant Create any index to user3;
CREATE ROLE high_manager_role;
CREATE ROLE middle_manager_role IDENTIFIED BY middlerole;
CREATE ROLE low_manager_role IDENTIFIED BY lowrole;
GRANT CONNECT,CREATE TABLE,CREATE VIEW TO low_manager_role;
GRANT CONNECT,CREATE TABLE,CREATE VIEW TO middle_manager_role;
GRANT CONNECT,RESOURCE,DBA TO high_manager_role;
GRANT SELECT,UPDATE,INSERT,DELETE ON scott.emp TO high_manager_role;