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

Thread: Triggers in SYSTEM schema

  1. #1
    Join Date
    Feb 2014

    Triggers in SYSTEM schema


    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
    Lake Worth, FL


    Quote Originally Posted by ora_venlo View Post

    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
    Pittsburgh, PA
    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