create session就是允许使用这个用户在服务器上创建session。通俗的说,就是允许这个用户登录。
例子:
SQL> conn / as sysdba
Connected.
// 建立一个新用户
SQL> create user testcreate identified by oracle;

User created.
//尝试登录,报错,没有 CREATE SESSION 权限
SQL> conn testcreate/oracle;
ERROR:
ORA-01045: user TESTCREATE lacks CREATE SESSION privilege; logon denied

Warning: You are no longer connected to ORACLE.

//授予create session权限
SQL> conn / as sysdba
Connected.
SQL> grant create session to testcreate;

Grant succeeded.
//再次登录,成功
SQL> conn testcreate/oracle;
Connected.

发表评论

邮箱地址不会被公开。 必填项已用*标注