Michael,

> 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

You can't, but you can generate a proper SQL script with
the following query.

select 'REVOKE ALL ON ' || rdb$relation_name || ' FROM PUBLIC;'
from rdb$relations
where rdb$view_blr is null
and (rdb$system_flag is null or rdb$system_flag = 0)



Regards,
Thomas Steinmaurer
http://www.iblogmanager.com

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