oracle如何添加用户并指定数据库


 imp cmsuser/password@orcl file=bubp20080708.dmp fromuser=cmsuser touser=cmsuser

        SQL> create user uumcuser identified by "password";

        User created.

        SQL> grantgrant connect,dba to uumcuser; SP2-0734: unknown command beginning "grantgrant..." - rest of line ignored. SQL> grant connect,dba to uumcuser;

        Grant succeeded.

        SQL> grant exp_full_database,imp_full_database,resource,create any sequence to cmsuser;

        Grant succeeded.

        SQL> grant create any trigger,create any view,create table,drop any view to uumcuser;

        Grant succeeded.

        SQL> grant exp_full_database,imp_full_database,resource,create any sequence to uumcuser;

        Grant succeeded.

 

本文作者:
« 
» 
快速导航

Copyright © 2016 phpStudy | 豫ICP备2021030365号-3