Trigger Visibility?? [message #38365] |
Mon, 15 April 2002 13:44 |
KAW
Messages: 8 Registered: February 2001
|
Junior Member |
|
|
I was told that triggers do not have permissions on them but I cannot see a trigger on a table but I can see the table.
1) Why is it I cannot see the trigger on a table?
2) Can I see a trigger if I do not have Create Trigger or ALTER priviledges?
|
|
|
Re: Trigger Visibility?? [message #38366 is a reply to message #38365] |
Mon, 15 April 2002 13:49 |
Mahesh
Messages: 90 Registered: January 2001
|
Member |
|
|
You should be able to see the triggers on a table in all_triggers table. Once you find out the name, you should be able to see the code in all_source or user_source tables.
|
|
|
Re: Trigger Visibility?? [message #38369 is a reply to message #38365] |
Mon, 15 April 2002 14:12 |
KAW
Messages: 8 Registered: February 2001
|
Junior Member |
|
|
In PROD I cannot see any triggers in all_triggers. The same goes for user_triggers system table also.
In DEV I can. Seems like some type of privileges to me.
ANy Ideas.
|
|
|