create user lvyi identified by "l123";//创建用户lvyi, 密码为123
SQL> create user lvyiidentified by "123";
User created.
SQL> grant connect,dba to lvyi;//赋予lvyi连接权限
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.