Create DB Links for Another User, Can We?
The answer is no, at least, not directly. You can see the reason why we can't create database links for another user in this post.… Read More »Create DB Links for Another User, Can We?
SYS_CONTEXT
How to Kill Session in Logon Trigger
Here I introduce a trigger which can log logon information on specific schemas. It will kill their sessions if they are not from specific subnet.… Read More »How to Kill Session in Logon Trigger
Oracle Who am I
Sometimes, you switched the connection to another schema for more operations and forgot where you are. Here are some ways to know who am I… Read More »Oracle Who am I