db & table privileges
Posted by:
Jacky Shu
Date: August 03, 2006 01:07PM
scenario:
in a 100 tables database, we need to deny access to one table and allows to all other tables.
we tried to allow on db level, but only deny on table level, but it didn't work.
instead, we had to remove privileges from db level, and allowed access to 99 other tables in that database.
obviously, this is not an ideal solution because we had to grant privileges to 99 tables!
is there anyway to work around this?
Thanks.
Jacky Shu
OCPDBA, MCDBA
Subject
Views
Written By
Posted
db & table privileges
2837
August 03, 2006 01:07PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.