Subject Change database owner / privileges for all tables of a database
Author Sibylle Koczian

how can I change the owner of a database, or grant privileges for _all_
tables of a database with one statement? GRANT doesn't seem to take
wildcards and in that section of the data definition guide there is no
mention at all of granting privileges to more than one table at once. Not
even select privilege, which might be appropriate in many cases.

Did I miss the right place to look for the information or isn't it possible?

Thank you,

Dr. Sibylle Koczian
Universitaetsbibliothek, Abt. Naturwiss.
D-86135 Augsburg

Tel.: (0821) 598-2400, Fax : (0821) 598-2410
e-mail : Sibylle.Koczian@...-Augsburg.DE