ORACLEÊý¾Ýµ¼Èëµ½Ö¸¶¨µÄ±í¿Õ¼ä

create user Óû§Ãû identified by ÃÜÂë default tablespace ȱʡ±í¿Õ¼ä¡¡Temporary tablespace ÁÙʱ±í¿Õ¼ä;­
­
grant connect,resource,dba to Óû§Ãû;­
¡¡¡¡­
revoke unlimited tablespace from Óû§Ãû;­
¡¡¡¡­
alter user Óû§Ãû quota 0 on Users;­
­
alter user Óû§Ãû¡¡quota unlimited on Óû§È±Ê¡±í¿Õ¼ä;­
­
--¹Ø¼üÊǺóÃæ3ÐÐÃüÁ±ØÐëÖ´ÐС£­
­
--½Ó×ÅʹÓÃIMP¹¤¾ßµ¼ÈëÊý¾Ý¼´¿Éµ¼Èëµ½Óû§È±Ê¡±í¿Õ¼ä. ­
 
--EXAMPLE:    USER NAME: GROUPCMS;     tablespace:GROUPCMS
--DROP USER GROUPCMS CASCADE;
create user GROUPCMS identified by ABC123 default tablespace GROUPCMS¡¡ ;
grant connect,resource,dba to GROUPCMS;
revoke unlimited tablespace from GROUPCMS;
alter user GROUPCMS quota 0 on Users;
alter user GROUPCMS¡¡quota unlimited on GROUPCMS;