|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
|
|
#1
April 17th, 2006, 12:36 PM
|
|||
|
|||
|
Trigger for all users?
Lets say i have a trigger for a table called "fruit", how do I apply the trigger to all fruit tables for all users within the database?
__________________
What can change the nature of a man?
|
|
#2
April 17th, 2006, 02:43 PM
|
||||
|
||||
|
Why not a single fruit table?
__________________
My blog Tutorials about OSS databases, DBMonster ... Contribute to OSS Development, fill bug reports! Developer Shed eSupport Commented my.ini/my.cnf (ADD YOUR OWN CONFIG TRICK) An introduction to database normalization Natural or Surrogate key Custom ordering for your results Correlated and uncorrelated subqueries Don't turn your outer joins into inner joins Random data (with a bias)
|
|
#3
April 17th, 2006, 03:12 PM
|
|||
|
|||
|
Pabloj has it right.
Otherwise, you will have to create the trigger in each user's schema. Which means every time you need to change/update the trigger or alter the table, then you need to create it in every schema. Again...and again.
|
|
#4
April 17th, 2006, 03:43 PM
|
||||
|
||||
|
If you want to create multiple tables for privacy reasons you'd better read Control access with Oracle grant security and Establish security policy with Oracle virtual private database
|
|
| Viewing: Dev Shed Forums > Databases > Oracle Development > Trigger for all users? |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
