Timeline for How to troubleshoot/debug Oracle permission problems
Current License: CC BY-SA 3.0
3 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Mar 3, 2014 at 22:29 | vote | accept | Andy Arismendi | ||
| May 27, 2012 at 22:45 | comment | added | Andy Arismendi |
I'm not having much luck with the trigger. I created 2 users to replicate the scenario. I tried to create a table as user1 in user2's tablespace and got the expected ORA-01031: insufficient privileges error but nothing was captured in the error_log table. I created the trigger as user1 and user2 and the two error_log tables created were empty after receiving the permission error. I also tried ON DATABASE but I had to run that one as the sys account because the test accounts didn't have enough permissions to do that.
|
|
| May 23, 2012 at 10:38 | history | answered | user1822 | CC BY-SA 3.0 |