oracle 创建表空间建立用户

CREATE TABLESPACE TS_ECARD_CUR DATAFILE
'D:\oracle\product\10.1.0\oradata\orcl\TS_ECARDCUR01.ORA' SIZE 50M AUTOEXTEND ON NEXT 100M MAXSIZE 2000M
LOGGING
ONLINE
PERMANENT
EXTENT MANAGEMENT LOCAL AUTOALLOCATE
BLOCKSIZE 8K
SEGMENT SPACE MANAGEMENT AUTO
FLASHBACK ON;

CREATE TABLESPACE TS_ECARD_HIS DATAFILE
'D:\oracle\product\10.1.0\oradata\orcl\TS_ECARDHIS01.ORA' SIZE 50M AUTOEXTEND ON NEXT 100M MAXSIZE 1000M
LOGGING
ONLINE
PERMANENT
EXTENT MANAGEMENT LOCAL AUTOALLOCATE
BLOCKSIZE 8K
SEGMENT SPACE MANAGEMENT AUTO
FLASHBACK ON;

CREATE TABLESPACE TS_ECARD_PHOTO DATAFILE
'D:\oracle\product\10.1.0\oradata\orcl\TS_ECARDPHOTO01.ORA' SIZE 50M AUTOEXTEND ON NEXT 100M MAXSIZE 1000M
LOGGING
ONLINE
PERMANENT
EXTENT MANAGEMENT LOCAL AUTOALLOCATE
BLOCKSIZE 8K
SEGMENT SPACE MANAGEMENT AUTO
FLASHBACK ON;

 
CREATE USER ECARD
IDENTIFIED BY VALUES '980541344ADA6695'   --ecard
DEFAULT TABLESPACE TS_ECARD_CUR
TEMPORARY TABLESPACE TEMP
PROFILE DEFAULT
ACCOUNT UNLOCK;
-- 3 Roles for ECARD
GRANT DBA TO ECARD;
GRANT RESOURCE TO ECARD WITH ADMIN OPTION;
GRANT CONNECT TO ECARD WITH ADMIN OPTION;
ALTER USER ECARD DEFAULT ROLE ALL;
-- 12 System Privileges for ECARD
GRANT DROP ANY VIEW TO ECARD WITH ADMIN OPTION;
GRANT DROP PUBLIC SYNONYM TO ECARD WITH ADMIN OPTION;
GRANT SELECT ANY DICTIONARY TO ECARD WITH ADMIN OPTION;
GRANT CREATE VIEW TO ECARD WITH ADMIN OPTION;
GRANT CREATE ANY SYNONYM TO ECARD WITH ADMIN OPTION;
GRANT CREATE PROCEDURE TO ECARD WITH ADMIN OPTION;
GRANT UNLIMITED TABLESPACE TO ECARD WITH ADMIN OPTION;
GRANT DROP ANY SYNONYM TO ECARD WITH ADMIN OPTION;
GRANT CREATE TABLE TO ECARD WITH ADMIN OPTION;
GRANT DROP ANY PROCEDURE TO ECARD WITH ADMIN OPTION;
GRANT CREATE PUBLIC SYNONYM TO ECARD WITH ADMIN OPTION;
GRANT DROP ANY TABLE TO ECARD WITH ADMIN OPTION;
-- 2 Tablespace Quotas for ECARD
ALTER USER ECARD QUOTA UNLIMITED ON TS_ECARD_HIS;
ALTER USER ECARD QUOTA UNLIMITED ON TS_ECARD_CUR;