ORACLE 10G´´½¨±í¿Õ¼äºÍ´´½¨Óû§

 1¡¢´´½¨±í¿Õ¼ä
CREATE TABLESPACE mytablespace DATAFILE   
  'F:\oracle\product\10.2.0\oradata\myoracle\MYTABLESPACE01.DBF' SIZE 500M AUTOEXTEND ON NEXT
100M MAXSIZE UNLIMITED  
LOGGING  
PERMANENT  
EXTENT MANAGEMENT LOCAL AUTOALLOCATE  
BLOCKSIZE 8K  
SEGMENT SPACE MANAGEMENT MANUAL  
FLASHBACK ON;
2¡¢´´½¨Óû§
CREATE USER ECC_NOTE IDENTIFIED BY sys
PROFILE DEFAULT
DEFAULT TABLESPACE mytablespace
TEMPORARY TABLESPACE temp
ACCOUNT UNLOCK;
GRANT UNDER ANY TABLE TO ECC_NOTE WITH ADMIN OPTION;  
 
GRANT UNDER ANY TYPE TO ECC_NOTE WITH ADMIN OPTION;  
 
GRANT UNDER ANY VIEW TO ECC_NOTE WITH ADMIN OPTION;  
 
 
GRANT "DBA" TO ECC_NOTE WITH ADMIN OPTION;  
GRANT "OLAP_DBA" TO ECC_NOTE WITH ADMIN OPTION;  
GRANT "OLAP_USER" TO ECC_NOTE WITH ADMIN OPTION;  
GRANT "SELECT_CATALOG_ROLE" TO ECC_NOTE WITH ADMIN OPTION;  
ALTER USER ECC_NOTE DEFAULT ROLE "DBA", "OLAP_DBA", "OLAP_USER", "SELECT_CATALOG_ROLE";  
 
ALTER USER test QUOTA UNLIMITED ON ECC_NOTE;