当前位置: 代码迷 >> 综合 >> connect 和create session的区别
  详细解决方案

connect 和create session的区别

热度:27   发布时间:2024-01-18 06:35:50.0

connect实际上是oracle数据库中的一种角色,他包含了create session等权限。

SYS@PRODCDB>select role,con_id from cdb_roles where role='CONNECT';ROLE                CON_ID
--------------- ----------
CONNECT                  3
CONNECT                  1
CONNECT                  4SYS@PRODCDB>select role,privilege from role_sys_Privs where role='CONNECT';ROLE            PRIVILEGE
--------------- ----------------------------------------
CONNECT         SET CONTAINER
CONNECT         CREATE SESSION

创建用户并授予connect权限

SYS@PRODCDB>create user oracle identified by oracle;User created.SYS@PRODCDB>grant connect to oracle;Grant succeeded.SYS@PRODCDB>select grantee,granted_role,con_id from cdb_role_privs where grantee='ORACLE';GRANTEE                      GRANTED_     CON_ID
---------------------------- -------- ----------
ORACLE                       CONNECT           1

授予用户create session权限

SYS@PRODCDB>grant create session to oracle;Grant succeeded.SYS@PRODCDB>select grantee,privilege,con_id from cdb_sys_privs where grantee='ORACLE';GRANTEE                      PRIVILEGE                                    CON_ID
---------------------------- ---------------------------------------- ----------
ORACLE                       CREATE SESSION                                    1SYS@PRODCDB>

  相关解决方案