ORACLE Êý¾Ý±í´´½¨²½Öè

1.´´½¨ÁÙʱ±í¿Õ¼ä
CREATE TEMPORARY TABLESPACE Test_temp
TEMPFILE 'E:\Test\TEST_temp.dbf'
SIZE 32M
AUTOEXTEND ON
NEXT 32M MAXSIZE 2048M
EXTENT MANAGEMENT LOCAL;
2.´´½¨Óû§±í¿Õ¼ä
create tablespace TEST
datafile 'E:\TEST\TEST.dbf'
size  100M
autoextend on maxsize      200M
extent management local uniform size  64K;
3.´´½¨Óû§²¢Öƶ¨±í¿Õ¼ä
CREATE USER TEST  IDENTIFIED BY TEST
DEFAULT TABLESPACE TEST
TEMPORARY TABLESPACE TEST_temp
profile DEFAULT;
 
GRANT UNLIMITED TABLESPACE TO TEST;
 
4.¸øÓû§ÊÚÓèȨÏÞ
        GRANT
¡¡¡¡    CREATE SESSION, CREATE ANY TABLE, CREATE ANY VIEW ,CREATE ANY INDEX,
       CREATE ANY PROCEDURE,
¡¡¡¡    ALTER ANY TABLE, ALTER ANY PROCEDURE,
¡¡¡¡    DROP ANY TABLE, DROP ANY VIEW, DROP ANY INDEX, DROP ANY PROCEDURE,
SELECT ANY TABLE, INSERT ANY TABLE, UPDATE ANY TABLE, DELETE ANY TABLE TO TEST;
5.´´½¨½ÇÉ«
CREATE ROLE "TestRole" NOT IDENTIFIED;
GRANT "CONNECT" TO "TestRole";
GRANT "DBA" TO "TestRole";
GRANT "RESOURCE" TO "TestRole";
6.ÊÚÓè½ÇÉ«
 GRANT DBATO TEST;
   ALTER USER TEST QUOTA 100M ON TEST;
      GRANT UNLIMITED TABLESPACE TO TEST;