Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: This guy is trying to steal my mates wife. 3060
"tojo" <TomJordanTojo_at_hotmail.com> wrote in message
news:MPG.172f67b86273b036989686_at_news.t-online.de...
> In article <ddb31653.0204230040.755457ff_at_posting.google.com>,
> markg_at_mymail.co.uk says...
> > Hmmm... this bloke is involved with too many women at once, is he some
> > kind of SHARED POOL.
> >
> > INTEGRITY CONSTRAINTS are severly violated here! Tell him to COMMIT
> > to one woman.
> >
> > ;-)
> >
> > M
> >
>
> Try this script...
>
> revoke alter partner from "Richard Harper";
>
> alter user "Richard Harper" quota 0 on other_women;
>
> audit select on my_buddy.wife by "Richard Harper" whenever successful;
>
>
> I'm sure there's others :)
>
I'd revoke any privileges to create session, or to insert...
Paul Received on Tue Apr 23 2002 - 14:39:27 CDT
![]() |
![]() |