orcale学习1

我用语句创建的，代码如下： 
--恢复数据库 


/*创建用户*/ 
CREATE   USER   ORADB   PROFILE   "DEFAULT " 
       IDENTIFIED   BY   ORADB   ; 

GRANT   UNLIMITED   TABLESPACE   TO   ORADB   ; 
GRANT   "CONNECT "   TO   ORADB   ; 
GRANT   "RESOURCE "   TO   ORADB   ; 
GRANT   "DBA "   TO   ORADB   
/ 


CREATE   USER   ROLE_CHANGGE     PROFILE   "DEFAULT " 
       IDENTIFIED   BY   ROLE_CHANGGE   ; 

GRANT   UNLIMITED   TABLESPACE   TO   ROLE_CHANGGE; 
GRANT   "CONNECT "   TO   ROLE_CHANGGE; 
GRANT   "RESOURCE "   TO   ROLE_CHANGGE 
/ 
创建的时候必须是dba身份才可以的。