Oracle创建datafile,tablefile,role,user随笔

此处代码为先将权限赋值给角色，再讲角色赋值给用户

create tablespace tp_liferay_xyong datafile '/home/oracle/wadess/tp_liferay_xyong01.dbf' size 100m,

'/home/oracle/wadess/tp_liferay_xyong02.dbf' size 100m;

create role normal_role;

grant connect,resource to normal_role;
grant create any sequence to normal_role;
grant create any table to normal_role;
grant delete any table to normal_role;
grant insert any table to normal_role;
grant select any table to normal_role;
grant execute any procedure to normal_role;
grant update any table to normal_role;
grant create any view to normal_role;

create user liferay_xyong identified by liferay_xyong
default tablespace tp_liferay_xyong
temporary tablespace temp;

grant normal_role to liferay_xyong; 

此处文件为独自建立表空间、临时表空间，并将它们赋值给用户。

这里的表空间是不可扩展的。

create tablespace tp_liferay_xyong datafile '/home/oracle/wadess/tp_liferay_xyong01.dbf' size 100m;

create temporary tablespace tp_liferay_xyong_temporary tempfile '/home/oracle/wadess/tp_liferay_xyong02.dbf' size 100m;

create user liferay_xyong identified by liferay_xyong
default tablespace tp_liferay_xyong
temporary tablespace tp_liferay_xyong_temporary;

grant connect,resource to liferay_xyong;
grant create any sequence to liferay_xyong;
grant create any table to liferay_xyong;
grant delete any table to liferay_xyong;
grant insert any table to liferay_xyong;
grant select any table to liferay_xyong;
grant execute any procedure to liferay_xyong;
grant update any table to liferay_xyong;
grant create any view to liferay_xyong;