地市分站
用户名
密  码
您现在的位置是:树人网首页 / 计算机等级考试 / oracle认证 / 文章浏览
数据库中LowcacheRBA和OndiskRBA的区别
文章来源:本站原创 发表时间:2008-07-07 点击次数
此函数在写一些触发器和函数的时候非常有用处。

  用法:

    SELECT sys_context('USERENV', '') FROM dual;

  第二个参数的可选值:

  AUTHENTICATION_DATA
  Data being used to authenticate the login user. For X.503 certificate authenticated sessions, this field returns the context of the certificate in HEX2 format.
  Note: You can change the return value of the AUTHENTICATION_DATA attribute using the length parameter of the syntax. Values of up to 4000 are accepted. This is the only attribute of USERENV for which Oracle implements such a change.

  AUTHENTICATION_TYPE
  How the user was authenticated:
  DATABASE: username/password authentication
  OS: operating system external user authentication
  NETWORK: network protocol or ANO authentication
  PROXY: OCI proxy connection authentication
  BG_JOB_ID
  Job ID of the current session if it was established by an Oracle background process. Null if the session was not established by a background process.
  CLIENT_INFO
  Returns up to 64 bytes of user session information that can be stored by an application using the DBMS_APPLICATION_INFO package.

  CURRENT_SCHEMA
  Name of the default schema being used in the current schema. This value can be changed during the session with an ALTER SESSION SET CURRENT_SCHEMA statement.

  CURRENT_SCHEMAID
  Identifier of the default schema being used in the current session.

  CURRENT_USER
  The name of the user whose privilege the current session is under.

  CURRENT_USERID
  User ID of the user whose privilege the current session is under.

  DB_DOMAIN
  Domain of the database as specified in the DB_DOMAIN initialization parameter.

  DB_NAME
  Name of the database as specified in the DB_NAME initialization parameter.

  ENTRYID
  The available auditing entry identifier. You cannot use this option in distributed SQL statements. To use this keyword in USERENV, the initialization parameter AUDIT_TRAIL must be set to true.

  EXTERNAL_NAME
  External name of the database user. For SSL authenticated sessions using v.503 certificates, this field returns the distinguished name (DN) stored in the user certificate.

  FG_JOB_ID
  Job ID of the current session if it was established by a client foreground process. Null if the session was not established by a foreground process.

  HOST
  Name of the host machine from which the client has connected.



第 页

责任编辑:qwer19871212

相关文章
公告栏

“蓝焰杯”第二届河南教育十大新闻人物火热评选中!!

点击参加评选,为你心目中的新闻人物投上一票>>>>
频道内容精选
[计算机考试]程序员必考的知识点
论坛/博客精选