CODEWITHSUNDEEP
oracle-databasetriggers
user2025098
user2025098

Reputation: 61

Disable logon trigger in Oracle

I have such problem as described in cannot login to sql server due logon trigger

But I use Oracle. Is there same thing like "Dedicated Admin Connection"? Or are there any other method to solve this problem?

Upvotes: 0

Views: 2892

Answers (2)

ibre5041
ibre5041

Reputation: 5288

Up to Oracle ver. 10g (including) the logon trigger was not fired for users having DBA role. Since ver. 11g it's fired also for DBA sessions, but its failure does not kill the session.

For all the other users any error thrown from the logon trigger kills the session.

So if you want to administer the logon trigger, you should connect as sysdba (sqlplus / as sysdba)

PS: also note, that aside from LOGON TRIGGER ON DATABASE there is also a LOGON TRIGGER ON SCHEMA which is less dangerous.

Upvotes: 2

Justin Cave
Justin Cave

Reputation: 231671

In Oracle, a user with the ADMINISTER DATABASE TRIGGER privilege should be able to log in even if a logon trigger throws an error. That should include any users with the DBA role.

Upvotes: 4

Related Questions