Oracle 架构所需的远程连接权限

SQL> create user demo identified by demo;

User created.

SQL> conn demo/demo
ERROR:
ORA-01045: user DEMO lacks CREATE SESSION privilege; logon denied


Warning: You are no longer connected to ORACLE.
SQL> conn / as sysdba
Connected.

SQL> grant create session to demo;

Grant succeeded.

SQL> conn demo/demo
Connected.
复制