Database Security Products (MOSC)

MOSC Banner

Revoke public access to one spefic table

edited Oct 8, 2009 12:12AM in Database Security Products (MOSC) 6 commentsAnswered
I am new to oracle....lets start with that.  The tables in our database have been added by using a middleware application.  All of our tables have the grantee as public and security is maintained using the middleware application. Currently our users only have access to the database through the middleware application but I want to link the database to an excel spreadsheet but I can not limit the table access from excel.  I also can not limit the table access though oracle because all the tables have public access.  I have tried to revoke select on table_name from public but when I login to a new session I still can view the data in this table.  How can I get around this?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center