| Subject | Change database owner / privileges for all tables of a database |
|---|---|
| Author | Sibylle Koczian |
| Post date | 2005-01-17T10:29:48Z |
Hello,
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,
Koczian
Dr. Sibylle Koczian
Universitaetsbibliothek, Abt. Naturwiss.
D-86135 Augsburg
Tel.: (0821) 598-2400, Fax : (0821) 598-2410
e-mail : Sibylle.Koczian@...-Augsburg.DE
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,
Koczian
Dr. Sibylle Koczian
Universitaetsbibliothek, Abt. Naturwiss.
D-86135 Augsburg
Tel.: (0821) 598-2400, Fax : (0821) 598-2410
e-mail : Sibylle.Koczian@...-Augsburg.DE