> > In Firebird versions below 2, a GRANT ALL would create a single row
> > in the RDB$PRIVILEGES table with a privilege of "A" (all)
>
> Are you sure? FB 1.5.x doesn't create a privilege of type "A" for me.
> And AFAIU FB 1.0 should neither. The engine internally replaces "A" with
> "SIUDR" before storing anything in RDB$USER_PRIVILEGES.

I _was_ sure - now I no longer am.

The InterBase documentation still lists:
UPDATE
ALL
REFERENCE
SELECT
DELETE
MEMBER OF (for roles)
INSERT

As a CHAR(6).

I'm pretty sure I have seen this behaviour, in that you had to use:
REVOKE ALL ... FROM ...

And then re-grant separate privileges.

Hmm...

Anyone with IB 5.6 cares to try? :)

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com