Oracle创建表空间、用户、授权等常规操作

tongy

/*
在服务器目录/optoracle/oradata/etld下创建表空间前，先手动建好etld目录，并用root用户给etld目录相应权限,如777
*/

--创建表空间
create tablespace tbs_etld_data
logging
datafile '/opt/oracle/oradata/etld/etld_data.dbf'
size 200m
autoextend on
next 50m maxsize 1024m
extent management local;
create temporary tablespace tbs_etld_temp
tempfile '/opt/oracle/oradata/etld/etld_temp.dbf'
size 100m
autoextend on
next 50m maxsize 1024m
extent management local;

--创建用户
create user etld identified by etld
default tablespace tbs_etld_data
temporary tablespace tbs_etld_temp;

//给用户授权
grant connect to etld;
grant resource to etld;
grant alter any index to etld;
grant alter any procedure to etld;
grant alter any sequence to etld;
grant alter any table to etld;
grant create any context to etld;
grant create any index to etld;
grant create any library to etld;
grant create any procedure to etld;
grant create any table to etld;
grant create any type to etld;
grant create any view to etld;
grant create procedure to etld;
grant drop any index to etld;
grant drop any library to etld;
grant execute any operator to etld;
grant execute any procedure to etld;
grant insert any table to etld;
grant select any table to etld;
grant unlimited tablespace to etld;  
grant debug connect session to etld;
grant select any dictionary to etld

到此，etld用户就可以使用了;

花蜻宽

我在马路边丢了一分钱

lig

丑，但是丑的特别，也就是特别的丑！

xxggmmxx

我在马路边丢了一分钱

刘伟

沙发！沙发!

iyth888

爱她，就请为她做无痛人流手术!

cheng029

勿以坑小而不灌，勿以坑大而灌之。