create user lvyi identified by "l123";//創(chuàng)建用戶lvyi, 密碼為123

SQL> create user lvyiidentified by "123";

User created.

SQL> grant connect,dba to lvyi;//賦予lvyi連接權(quán)限

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.

總結(jié)

以上是生活随笔為你收集整理的java创建oracle用户_oracle添加用户并指定数据库的全部內(nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯，歡迎將生活随笔推薦給好友。