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

Thread: system trigger

  1. #1
    Join Date
    Oct 2001
    Posts
    1

    Exclamation

    hi,
    i create the system trigger on logon, the trigger updat the data base, the problem if i log on , the oracle error :system trigger update or delete on database , however the user create with grant to create anther user, DDL and MDL

  2. #2
    Join Date
    Aug 2001
    Location
    Waterloo, On
    Posts
    547
    I think your question is not very clear, that's why you have'nt got a response yet.
    Will you elaborate your problem?
    If possible, give out the trigger code so that someone here can help you.

    Raminder Singh

    Oracle Certified DBA: Oracle 8i, 9i


    Mail me at raminderahluwalia@rediffmail.com.

  3. #3
    Join Date
    Sep 2001
    Location
    NJ, USA
    Posts
    1,287
    If this is ON-LOGON trigger in Oracle Forms?

    If yes, then you can't execute any DB command before you not logon to DB.
    ON-LOGON - reject standard ON-LOGON Forms procedure and you should logon to DB manually.

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