日期:2014-05-16  浏览次数:20345 次

Oracle创建表空间、创建用户以及授权、查看权限

创建临时表空间

CREATE?TEMPORARY?TABLESPACE?test_temp
SIZE?32M
NEXT?32M?MAXSIZE?2048M
EXTENT?MANAGEMENT?LOCAL;

创建用户表空间

CREATE?TABLESPACE?test_data
DATAFILE?
'C:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\TEST_DATA01.DBF'?
AUTOEXTEND?
ON?
EXTENT?MANAGEMENT?LOCAL;

创建用户并制定表空间

CREATE?USER?username?IDENTIFIED?BY?password
TEMPORARY?TABLESPACE?TEST_TEMP;

给用户授予权限

GRANT?
  
ALTER?ANY?TABLE,?ALTER?ANY?