Oracle 表空间及用户创建 sql 语句

来源:互联网 时间:1970-01-01

CREATE  TABLESPACE hdyljspatial
LOGGING
DATAFILE 'E:/oracle11g/oradata/orcl/hdyljspatial.DBF' SIZE 512M REUSE AUTOEXTEND ON NEXT 100M MAXSIZE 32767M
EXTENT MANAGEMENT LOCAL SEGMENT
SPACE MANAGEMENT AUTO;

CREATE USER hdyljspatial PROFILE "DEFAULT"
IDENTIFIED BY hdyljspatial DEFAULT TABLESPACE hdyljspatial
TEMPORARY TABLESPACE "TEMP"

GRANT "CONNECT" TO hdyljspatial
GRANT "RESOURCE" TO hdyljspatial
GRANT UNLIMITED TABLESPACE TO hdyljspatial
GRANT EXECUTE ON DBMS_UTILITY TO hdyljspatial
GRANT CREATE ANY TABLE TO hdyljspatial
GRANT ALTER ANY TABLE TO hdyljspatial
GRANT DROP ANY TABLE TO hdyljspatial

grant change notification to hdyljspatial;

grant dba to  hdyljspatial


相关阅读:
Top