OraFAQ Forum: Security » Possible to findout the module from Updating?

Home » RDBMS Server » Security » Possible to findout the module from Updating? (Oracle 9i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Possible to findout the module from Updating? [message #349759]

Tue, 23 September 2008 00:59

mm_kanish05
Messages: 493
Registered: January 2007
Location: Chennai

Senior Member

Hi
I have trigger, in which i want to identify the Module through which the people update/insert/delete(isqlplus/sql developer/form/reports)

I had seen that v$session but i can't use it in the trigger.

Any possible please help me

Thank in advance

kanish

Report message to a moderator

Re: Possible to findout the module from Updating? [message #349765 is a reply to message #349759]

Tue, 23 September 2008 01:15

Michel Cadot
Messages: 68499
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

dbms_application_info.read_module

Regards
Michel

Report message to a moderator

Re: Possible to findout the module from Updating? [message #349769 is a reply to message #349759]

Tue, 23 September 2008 01:29

mm_kanish05
Messages: 493
Registered: January 2007
Location: Chennai

Senior Member

Thanks i got it

[Updated on: Tue, 23 September 2008 01:47]

Report message to a moderator

Re: Possible to findout the module from Updating? [message #349780 is a reply to message #349759]

Tue, 23 September 2008 01:58

mm_kanish05
Messages: 493
Registered: January 2007
Location: Chennai

Senior Member

One More question

Can i know the Client Machine name (from where he has done)

kanish

Report message to a moderator

Re: Possible to findout the module from Updating? [message #349791 is a reply to message #349780]

Tue, 23 September 2008 02:41

Michel Cadot
Messages: 68499
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

All the informations you can have are in USERENV namespace, see SYS_CONTEXT.

Quote:

HOST: Name of the host machine from which the client has connected.

Regards
Michel

Report message to a moderator

Previous Topic:	Audit inside trigger activity
Next Topic:	revoke role

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 21 11:52:07 CDT 2023