Re[1]: FGAC and application contexts help !

From: Prem Khanna J <premj_at_rediffmail.com>
Date: 20 Aug 2004 12:29:32 -0000
Message-ID: <20040820122932.32360.qmail@webmail9.rediffmail.com>

Hi Tanel,
Thanks for your reply.
we want to have APPS username based access control.

Below is the procedure is use to get the USER_ID of application user.This procedure in turn is being used by DBMS_FGA as shown below .

CREATE OR REPLACE PROCEDURE fga.aud_pro ( schema_name VARCHAR2,
table_name VARCHAR2,
policy_name VARCHAR2 )
IS
appuserid number;
appusername varchar2(30);
BEGIN
SELECT user_id , user_name into appuserid , appusername from apps.fnd_user where
user_id = apps.fnd_profile.value('user_id');

INSERT INTO AUD_LOG VALUES (
appuserid,appusername,table_name,policy_name,sysdate ) ; END; EXECUTE DBMS_FGA.ADD_POLICY (-

OBJECT_SCHEMA => 'APPLSYS',- 
OBJECT_NAME => 'FND_CONCURRENT_PROGRAMS',- 
POLICY_NAME => 'TEST_POLICY',-

AUDIT_CONDITION => 'CONCURRENT_PROGRAM_NAME = ''TESTPRG''',- AUDIT_COLUMN => 'CONCURRENT_PROGRAM_NAME',- HANDLER_SCHEMA => 'FGA',-
HANDLER_MODULE => 'AUD_PRO',-
ENABLE => TRUE );

But the user_id and user_name returned is "-1" and "ANONYMOUS" and not the correct one.How do i get the proper values ? Any profile setting to be done in APPS ?!

The environment is Oracle EBS 11.5.9/ Oracle 9.2.0.4/ AIX5.2L.

Thanks & Regards,
Prem.

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

Received on Fri Aug 20 2004 - 07:25:18 CDT