Triggers in SYSTEM schema
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Triggers in SYSTEM schema

  1. #1
    Join Date
    Feb 2014
    Posts
    19

    Triggers in SYSTEM schema

    Hi,

    Our head of developers wants to register when certain osusers are connecting with which oracle user and when they are logging off.
    He wants to put 2 triggers in the SYSTEM schema for that.
    I myself think it is better to leave the SYSTEM schema to Oracle and create an own schema in which the triggers reside. Is it wise to put 2 of such triggers in the SYSTEM schema?

  2. #2
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,477

    Cool

    Quote Originally Posted by ora_venlo View Post
    Hi,

    Our head of developers wants . . .
    . . . Is it wise to put 2 of such triggers in the SYSTEM schema?
    Due to the fact that "developers" should not be doing any kind of database task but rather the DBA, system and database triggers should reside under the SYSTEM account.
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

  3. #3
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,001
    Why don't you just use Auditing?
    this space intentionally left blank

Posting Permissions

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



Click Here to Expand Forum to Full Width