Results 1 to 4 of 4

Thread: user_objects

  1. #1
    Join Date
    May 2003
    Posts
    58

    Unanswered: user_objects

    The oracle database that I am working has a username called "SHARED". Someone issued a DDL statement on a package this morning at 11 AM. Is there a way to find which user (user name) issued it?

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >Is there a way to find which user (user name) issued it?
    You tell us. It is your DB, not ours.
    Is DDL auditing enabled?
    If not, You're On Your Own (YOYO)!
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    May 2003
    Posts
    58
    Hi auditing is not turned on. I checked alert.log and found nothing. Let's say the userid is "xyz". I have access to that userid and some other people have too. Is there a quick way to find out who logged into the system with that userid on that particular day?

  4. #4
    Join Date
    Apr 2003
    Location
    NY
    Posts
    208
    Depending on the time between executions, you can check the V$ tables.

    You can use V$SqlArea to look at SQL statements
    and V$Session to see who ran the statements.

    You tie the 2 together with the Address columns.

    HIH

Posting Permissions

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