Well,

GRANT ALL ON <table> TO PUBLIC

is the closest I know of. Of course, you could write a stored procedure
that get all the table names using the query found at
http://www.fbtalk.net/ViewTopic.aspx?id=139, add the GRANT ALL statement
above before and after each table and use EXECUTE STATEMENT. But I don't
think there is any statement that could grant all on tables not yet
created, that is, unless you use the embedded version that I don't think
use any user authentication at all (but then it isn't really multiuser).

HTH,
Set

rj1102 wrote:

> What is the easiest way to grant all rights to all users for a database.
> I'm looking for something like GRANT ALL TO ALL.
> I.e even when i create a new table in the database, access will be
> automatically granted to all users.
> Thanks Robert