×ܽáoracle³£ÓõÄÓï¾ä

1.         ÔÚoracle10gÖн¨Á¢±í¿Õ¼ä
create tablespace test datafile 'D:\oracle\product\10.1.0\oradate\test.dbf' size 500m autoextend on next 100m
maxsize unlimited
logging
permanent
extent management local autoallocate
blocksize 8k
segment space management manual
flashback on;
2.   ÔÚoracle 10g Öд´½¨±íÓû§
CREATE USER test IDENTIFIED BY "test" 
 DEFAULT TABLESPACE "TEST" 
 TEMPORARY TABLESPACE "TEMP" 
 PROFILE DEFAULT 
 QUOTA UNLIMITED ON "TEST";  
GRANT UNDER ANY TABLE TO test WITH ADMIN OPTION;   
GRANT UNDER ANY TYPE TO test WITH ADMIN OPTION;  
GRANT UNDER ANY VIEW TO test WITH ADMIN OPTION;   
GRANT "DBA" TO test WITH ADMIN OPTION;  
GRANT "OLAP_DBA" TO test WITH ADMIN OPTION;  
GRANT "OLAP_USER" TO test WITH ADMIN OPTION;  
GRANT "SELECT_CATALOG_ROLE" TO test WITH ADMIN OPTION;  
ALTER USER test DEFAULT ROLE "DBA", "OLAP_DBA", "OLAP_USER", "SELECT_CATALOG_ROLE";  
ALTER USER test QUOTA UNLIMITED ON TEST;
3.´´½¨oracle ʵÀý
drop user xd(̞) CASCADE;
-- Create the user
create user xd
  identified by xd
  default tablespace SYSTEM
  temporary tablespace TEMP
  profile DEFAULT;
-- Grant/Revoke role privileges
grant connect to xd with admin option;
grant resource to xd with admin option;
grant dba to xd with admin option;
4.²é¿´Óû§µÄȨÏÞ
select * from user_sys_privs;
5.²é¿´Óû§ÏÂËùÓеıí
Select * from  user_tables;
6´´½¨role²¢ÊÚȨ¸ø Óû§
Create role myrole;
Grant myrole to test
7.Ϊ±íÓû§ÊÚÓè²Ù×÷
grant create session to test with admin option;
grant unlimited session to test with admin option;
grant create table to test with admin option;
grant drop table to test with admin option;
grant insert table to test with admin option;
grant update table to  test with admin option;