Hi,

> Can I revoke on all tables at one time ?
>
> I know I can do this:
>
> Revoke all on MyTable from public
>
>
> But can I do something like
>
> Revoke all on "AllTables" from public

PS: What you CAN do, however, is something like this:

SELECT 'REVOKE <stuff> ON ' || RDB$RELATION_NAME || ' FROM PUBLIC;'
FROM RDB$RELATIONS
WHERE (RDB$SYSTEM_FLAG IS NULL or RDB$SYSTEM_FLAG = 0)


This will generate a script in the output.


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