Granting priveleges

From: Peter Chan <chanp_at_nortel.ca>
Date: 1998/02/06
Message-ID: <34DB64A9.259F@nortel.ca>#1/1

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