Andreas' Adventures

Installation 9.0.4 Collaboration Suite with RH 3.0 needs the following setting: LD_ASSUME_KERNEL=2.4.19 If you receive a SSORunning INVALID move the /etc/oratab to a new file and create an oratab with only the asdb entry.

Yes, they will! DBMS_JOB executes in the context of a user. Use the following to test: Create a table: create table out_ctx (usr_ctx number); Create a procedure: create procedure test_ctx as usr_ctx number; begin select sys_context('MY_CONTEXT','USER_ID') into usr_ctx from dual; insert into out_ctx values (usr_ctx); commit; end; Spool the job: BEGIN DBMS_JOB.SUBMIT(:jobno, 'test_ctx;', SYSDATE, 'SYSDATE + 1/720'); COMMIT; END; / PRINT jobno Check the result: select * from out_ctx; Delete the job: BEGIN DBMS_JOB.REMOVE(&job_number); END; /

Use Note 69408.1 Create the kkoipt_table, set the event to 10060 and do some tests Another great source of information is http://www.petefinnigan.com/papers/rls.sql

This will be a quick guide on how to use the VPD feature in an Oracle database. Start with creating a package that will fill your context. create or replace package user.mypackage is procedure set_user_id_context; end; Here comes the package body: create or replace package body user.mypackage is procedure set_user_id_context is sec_user_id number; begin -- -- in this case we have a table that holds my users and each user has a code -- select code into sec_user_id from usr where upper(id) = upper( sys_context( 'USERENV' ,'SESSION_USER...