Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Simple Grant Role question.
> 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
![]() |
![]() |