此处代码为先将权限赋值给角色,再讲角色赋值给用户
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;