DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: How to find user name or login name?

  1. 06-04-2009, 04:21 AM #1
    Siva Parvathi
    Siva Parvathi is offline Junior Member
    Join Date
    Jun 2009
    Posts
    1

    Unhappy How to find user name or login name?

    Hi Gurus,
    Please save me from this situation.
    I have a problem where I need to find out who logged on to the session and fired any DML command on a table.

    I thought of writing a trigger, but could not find any way to retrieve the user name who fired the query on the table.

    Please throw some light on this situation.....

    Many many thanks in Advance....
    Reply With Quote Reply With Quote
  2. 06-04-2009, 05:30 AM #2
    davey23uk
    davey23uk is offline Senior Advisor
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    use auditing
    Reply With Quote Reply With Quote
  3. 06-08-2009, 08:41 AM #3
    LKBrwn_DBA's Avatar
    LKBrwn_DBA
    LKBrwn_DBA is offline Senior Advisor
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,492

    Cool Sys_context()

    Try SYS_CONTEXT() function.
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Click Here to Expand Forum to Full Width