10/31/2023 0 Comments Pl sql developer oracle logonYou can watch the video tutorial on my YouTube channel on the same topic where I created and tested the trigger live. That is how we create a LogOn event trigger in Oracle Database. This trigger will fire every time HR user logs on to the database and respective values will be stored into the table which we just created in the step 2. The only thing which is left is the trigger. Now you are connected to the database using the desired user and also have the table ready to store the data. Step3: Write the trigger Logon Schema Event Trigger. Next you will need a table to store the logon and logoff data. Or if you are using SQL Developer then read here on how to connect to the database using the same. For the demonstration I will connect using my HR user. Step 1: Connect to the databaseĬonnect to the database using the user/schema in which you want to create the trigger. In this case what HR can do is, create event triggers on Log on and log off database event in its own schema. Suppose user HR is a control freak and wants to monitor its every log on and log off activity. Please watch the video tutorial for detailed explanation of the syntax. Suggested Reading: Introduction To Privileges In Oracle Database Syntax CREATE OR REPLACE TRIGGER trigger_nameīEFORE | AFTER database_event ON database/schema
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |