Create Stored Procedure For Logon Trigger with user SYSTEM gives ORA-00942 oracle 创建登录触发器,报错 ORA-00942
Create Stored Procedure For Logon Trigger with user SYSTEM gives ORA-00942 [ID 730793.1]
Modified 24-JUN-2009 Type PROBLEM Status PUBLISHED In this Document
Applies to:
Oracle Server - Enterprise Edition - Version: 10.2.0.1
This problem can occur on any platform. Symptoms
Creating a audit table and Stored Procedure for LOGON Trigger as SYSTEM
connect system/pw
CREATE TABLE logonaudittable
(
event VARCHAR2(10),
sid NUMBER,
serial# NUMBER,
timestamp DATE,
username VARCHAR2(30),
osuserid VARCHAR2(30),
machinename VARCHAR2(64)
)
tablespace QC_DATA
Table created.
SQL>create or replace procedure sp1
2 is
3 machinename VARCHAR2(64);
4 osuserid VARCHAR2(30);
5 v_sid NUMBER(10);
6 v_serial NUMBER(10);
7 CURSOR c1 IS
热门文档