代码有错 SELECT AUDSID,SYSDATE,NULL,SYS.LONG_USER,MACHINE,SYS_CONTEXT SYS.LONG_USER应该为SYS.LOGIN_USERWHERE OTHERS THEN WHERE应为WHEN
这段代码 SELECT AUDSID,SYSDATE,NULL,SYS.LOGIN_USER,MACHINE,SYS_CONTEXT('USERENV','IP_ADDRESS'),PROGRAM FROM V$SESSION WHERE AUDSID=USERENV('SESSIONID'); 能给我解释以下吗?
编译出现这样的错误 The following error has occurred:TRIGGER SYSTEM.LOGIN_ON_INFO On line: 4 PLS-00201: 必须说明标识符 'SYS.V_$SESSION'
你的权限不足,用internal/oracle登录
下面的触发器的错误怎样修改? CREATE OR REPLACE TRIGGER DROP_INFO AFTER DROP ON DOCMAN.SCHEMA BEGIN INSERT INTO SYSTEM.DROP_LOG( SESSION_ID, DROP_TIME, IP_ADDRESS, OBJECT_OWNER, OBJECT_NAME, OBJECT_TYPE, DROP_BY_USER) VALUES(USERENV('SESSIONID'), SYSDATE, SYS.CONTEXT('USERENV','IP_ADDRESS'), SYS.DICTIONARY_OBJ_OWNER, SYS.DICTIONARY_OBJ_NAME, SYS.DICTIONARY_OBJ_TYPE, SYS.LOGIN_USER); END; The following error has occurred:TRIGGER SYS.DROP_INFO On line: 12 PLS-00201: 必须说明标识符 'SYS.CONTEXT'
ERROR:
ORA-04098: 触发器 'SYS.LOGIN_OFF_INFO' 无效且未通过重新确认
ERROR:
ORA-24315: 非法的属性类型
SELECT AUDSID,SYSDATE,NULL,SYS.LONG_USER,MACHINE,SYS_CONTEXT
SYS.LONG_USER应该为SYS.LOGIN_USERWHERE OTHERS THEN
WHERE应为WHEN
SELECT AUDSID,SYSDATE,NULL,SYS.LOGIN_USER,MACHINE,SYS_CONTEXT('USERENV','IP_ADDRESS'),PROGRAM
FROM V$SESSION WHERE AUDSID=USERENV('SESSIONID');
能给我解释以下吗?
AUDSID 表示什么意思?
SYS.LOGIN_USER中的SYS是表示SYS用户吗?
SYS_CONTEXT('USERENV','IP_ADDRESS') 表示什么意思?
AUDSID=USERENV('SESSIONID') 表示什么意思?
SYS.LOGIN_USER中的SYS是表示SYS用户下的函数
SYS_CONTEXT('USERENV','IP_ADDRESS') 返回当前用户的ip地址
USERENV('SESSIONID') 当前session号
????????
The following error has occurred:TRIGGER SYSTEM.LOGIN_ON_INFO
On line: 4
PLS-00201: 必须说明标识符 'SYS.V_$SESSION'
CREATE OR REPLACE TRIGGER DROP_INFO
AFTER DROP ON DOCMAN.SCHEMA
BEGIN
INSERT INTO SYSTEM.DROP_LOG(
SESSION_ID,
DROP_TIME,
IP_ADDRESS,
OBJECT_OWNER,
OBJECT_NAME,
OBJECT_TYPE,
DROP_BY_USER)
VALUES(USERENV('SESSIONID'),
SYSDATE,
SYS.CONTEXT('USERENV','IP_ADDRESS'),
SYS.DICTIONARY_OBJ_OWNER,
SYS.DICTIONARY_OBJ_NAME,
SYS.DICTIONARY_OBJ_TYPE,
SYS.LOGIN_USER);
END;
The following error has occurred:TRIGGER SYS.DROP_INFO
On line: 12
PLS-00201: 必须说明标识符 'SYS.CONTEXT'
是SYS_CONTEXT('USERENV','IP_ADDRESS')
用SQLPLUSW登陆,LOGON_ON_TIME列有值,如果在SQLPLUSW中输入命令EXIT退出,LOGON_OFF_TIME列有值,如果点击右上方的*关闭,则LOGON_OFF_TIME列为空。(无论哪个用户)