Hi,

> At 02:51 PM 4/04/2003 +1000, you wrote:
> >OK Sorry - slightly wrong syntax on my revoke statement
> >funny that the syntax error does not create an exception.. why is this?
> >e.g.
> >revoke all ON DESKTOPUSER FROM "01CLARKKENT"
> >does not raise an error??
>
> What error do you expect?
>
> 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? 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>?



With regards,

Martijn Tonies
Database Workbench - the developer tool for InterBase & Firebird
Upscene Productions
http://www.upscene.com

See you at the First European Firebird Conference in May in Fulda, Germany
http://www.firebird-conference.com