文档下载 文档下载导航
设为首页 | 加入收藏
搜索 请输入内容:  
 导航当前位置: 文档下载 > 所有分类 > IT/计算机 > 计算机软件及应用 > Create Stored Procedure For Logon Trigger with user SYSTEM gives ORA-00942 [ID 730793.1]
侵权投诉

Create Stored Procedure For Logon Trigger with user SYSTEM gives ORA-00942 [ID 730793.1]

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

第1页

你可能喜欢

热门文档

站点地图 | 文档上传 | 侵权投诉 | 手机版
本站所有资源均来自互联网,本站只负责收集和整理,均不承担任何法律责任,如有侵权等其它行为请联系我们.
文档下载 Copyright 2013 doc.guandang.net All Rights Reserved.  -  email