创建用户: CREATE USER itpux IDENTIFIED BY itpux DEFAULT TABLESPACE datadbs TEMPORARY TABLESPACE tmpdbs; 删除用户: DROP USER itpux; 删除用户及包含的对象: DROP USER itpux CASCADE; 获取用户信息的数据字典: DBA_USERS DBA_TS_QUOTAS |
权限管理:
GRANT CREATE SESSION TO itpux; GRANT CREATE SESSION TO itpux WITH ADMIN OPTION; REVOKE CREATE TABLE FROM itpux; GRANT EXECUTE dbms_output TO itpux; GRANT UPDATE ON itpux2.tab1 TO itpux WITH GRANT OPTION; REVOKE SELECT ON itpux2.tab1 FROM itpux; 查询权限的数据字典: DBA_SYS_PRIVS SESSION_PRIVS DBA_TAB_PRIVS DBA_COL_PRIVS |
练习:
create user itpux2 identified by itpux2 default tablespace itpux_dbs temporary tablespace tmp_dbs; grant dba to itpux2; drop user itpux1 cascade; drop tablespace itpux1_dbs including contents and datafiles; |