java创建oracle用户_oracle添加用户并指定数据库

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.

总结

以上是生活随笔为你收集整理的java创建oracle用户_oracle添加用户并指定数据库的全部内容，希望文章能够帮你解决所遇到的问题。

如果觉得生活随笔网站内容还不错，欢迎将生活随笔推荐给好友。