Sure you can. The owner of the table is the one who grants that privilege
to the role.
--
Terry Dykstra [TeamPS]
Canadian Forest Oil Ltd.
Peter Chan <chanp_at_nortel.ca> wrote in article <34DB64A9.259F_at_nortel.ca>...
> I was wondering why I can grant a role to be able to select on all
> tables but unable to grant a role to be able to select on a specific
> table.
>
> ie.
>
> GRANT SELECT ANY TABLE TO "MY_ROLE";
>
> GRANT SELECT ON "TEMP_USER"."TEMP_TABLE" TO "MY_ROLE";
>
>
> Thanks!
> --
>
>
> ======================================================================
>
> PETER CHAN
> Northern Telecom
> Incremental Software Delivery
>
> PHONE: (613) 763-9096 EMAIL: chanp_at_nortel.ca
> FAX: (613) 763-4408
>
> ======================================================================
>
Received on Fri Feb 06 1998 - 00:00:00 CST
