Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Simple Grant Role question.

Re: Simple Grant Role question.

From: Nicolas Bronke <newsgroup_at_trinity.de>
Date: Fri, 14 Jan 2000 15:45:23 +0100
Message-ID: <387f3ceb_3@news2.prserv.net>


> Is it possible to grant multiple tables to a role? This is because I try
> the following statements but failed.
>
> i) grant select on table_A, table_B to select_role
> ii) grant select on (table_A, table_B) to select_role
>

Use a grant command for each table.

--
Regards
Nicolas Bronke Received on Fri Jan 14 2000 - 08:45:23 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US