oracle 20130909

来源：互联网发布：网络最新流行词语编辑：程序博客网时间：2024/06/07 22:07

CREATE USER yzq
IDENTIFIED BY orcl
DEFAULT TABLESPACE USERS
TEMPORARY TABLESPACE TEMP;
--创建用户
GRANT CONNECT TO yzq; --授权
GRANT RESOURCE TO yzq;
GRANT CREATE SEQUENCE TO yzq;
ALTER USER yzq IDENTIFIED BY newpass; --修改密码
DROP USER yzq CASCADE; --删除用户

-- 创建表空间
CREATE SMALLFILE TABLESPACE maintablespace DATAFILE 'e:\db/maintablespace'
SIZE 500M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO ;

-- 创建临时表空间
CREATE SMALLFILE TEMPORARY TABLESPACE temptablespace TEMPFILE
'e:\db/temptablespace' SIZE 200M AUTOEXTEND ON NEXT 25M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M; --e:\db/temptablespace：表空间文件的存放路径
--创建用户
create user userorcl
identified by "pass123"
default tablespace maintablespace
temporary tablespace temptablespace
profile DEFAULT;

--为用户授权
grant connect to userorcl with admin option;
grant dba to userorcl with admin option;
grant unlimited tablespace to userorcl with admin option;

--取消权限
revoke connect from userorcl ;
revoke dba FROM userorcl ;
revoke unlimited tablespace FROM userorcl;

--ddl 数据定义语言 create/drop/alter user table tablespace
--dml 数据操作语言 select/update/delete/insert
--dcl 数据控制语言 grant/revoke
--tcl 事物控制语言 commit/rollback/savepoint