At 09:57 AM 4/04/2003 +0200, you wrote:

> > Also, do you realise that ALL is a different privilege from the individual
> > DELETE, INSERT, UPDATE and REFERENCES privileges? REVOKE ALL will only
> > revoke privileges that were granted with GRANT ALL.
>
>Why is this anyway?

Because they are different privileges. If you don't want a user to have
ALL then don't use GRANT ALL...

>It means you have to go through REVOKE <privilege>
>for all privileges while ALL could do the same. Can you GRANT ALL
>and REVOKE <privilege>?

Nope.

It's to encourage you to document your security setup. :))

heLen