grant priveledges to for multiple tables

From: Brian Lavender <blavender_at_spk.usace.army.mil>
Date: Wed, 09 Dec 1998 19:44:07 GMT
Message-ID: <74mju7$kj7$1@nnrp1.dejanews.com>

My DBA created a user role titled role_foo. She will soon give me the capability to grant priveledges too.

Say I have the tables named in my database: FRED, BARNEY, WILMA, BETTY. I know I can issue the statement:

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

Can issue the following statement? If I can't is there an easy way to issue priveledges to multiple tables?

grant select, update, delete, insert on FRED, BARNEY, WILMA, BETTY to role_foo;

brian
--

Brian E. Lavender
US Army Corps of Engineers -- Programmer / Systems Analyst Sacramento, CA (916) 557-6623

-----------== Posted via Deja News, The Discussion Network ==----------
http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Dec 09 1998 - 13:44:07 CST