创建表空间
create tablespace casey_data
logging
datafile 'D:\oracle\oradata\casey_data.dbf'
size 20m
autoextend on
next 32m maxsize 2048m
extent management local;
创建用户
create user userName identified by password; //不指定表空间
create user casey identified by casey123 default tablespace casey_data;//指定表空间
用户授权(开发环境一般加上dba权限)
grant resource,connect to casey;
删除表空间
drop tablespace casey_data //删除逻辑表空间
drop tablespace casey_data including contents and datafiles //彻底删除表空间
删除用户
drop user casey cascade
修改表空间
alter tablespace casey_data add datafile 'D:\oracle\oradata\casey_data2.dbf' size 200M
权限操作
grant dba to casey;--授予DBA权限到用户casey
grant unlimited tablespace to casey;--授予不限制的表空间权限到用户casey
grant select any table to casey;--授予查询任何表权限到用户casey
grant select any dictionary to casey;--授予查询任何字典的权限到用户casey