How do I grant priveledges to multiple tables?

From: Brian Lavender <brian_at_brie.com>
Date: Tue, 15 Dec 1998 06:38:56 GMT
Message-ID: <3676039f.43143868@news.pacbell.net>

Say I have the tables named in my database: FRED, BARNEY, WILMA, BETTY. I know I can issue the statement to grant priveledges to a single table:

grant select, update, delete, insert on FRED to role_foo;

Is there a shortcut to granting these priveledges to all the tables in a simple step?

brian

---

Brian E. Lavender
http://www.brie.com/brian/

"For every complex problem, there is
a solution that is simple, neat, and
wrong." -- H. L. Mencken Received on Tue Dec 15 1998 - 00:38:56 CST