oracle添加用戶並指定數據庫

　　imp cmsuser/password@orcl file=bubpdmp fromuser=cmsuser touser=cmsuser

　　SQL> create user uumcuser identified by password;

　　User created

　　SQL> grantgrant connectdba to uumcuser; SP: unknown command beginning grantgrant rest of line ignored SQL> grant connectdba to uumcuser;

　　Grant succeeded

　　SQL> grant exp_full_databaseimp_full_databaseresourcecreate any sequence to cmsuser;

　　Grant succeeded

　　SQL> grant create any triggercreate any viewcreate tabledrop any view to uumcuser;

　　Grant succeeded

　　SQL> grant exp_full_databaseimp_full_databaseresourcecreate any sequence to uumcuser;

　　Grant succeeded

From:http://tw.wingwit.com/Article/program/Oracle/201311/17382.html