熱點推薦:
您现在的位置: 電腦知識網 >> 編程 >> Oracle >> 正文

oracle添加用戶並指定數據庫

2013-11-13 15:50:25  來源: 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
    Copyright © 2005-2013 電腦知識網 Computer Knowledge   All rights reserved.