On Thu, 9 Mar 2006, Stephen Frost wrote: > * Jonah H. Harris ([EMAIL PROTECTED]) wrote: > > On 3/9/06, William ZHANG <[EMAIL PROTECTED]> wrote: > > > Or should we let > > > DROP TABLE foo CASCADE; > > > to drop the SYNONYMS depended on the table? > > > > Yes, I don't see any reason not to allow a cascading table drop include > > synonyms that reference them. > > Should a non-cascade drop fail or just implicitly drop the synonyms? > I'm not sure which way I feel about this... Users with only 'select' > permissions on a given object can't currently create objects which > depend on that object (such that dropping the object would then require > 'cascade'), can they?
I think a user can create a view to a table they only have select on right now and that should prevent non-cascade drops as well. ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
