Hi,
I'm hoping you guys can help me with this. I'm trying to hide specific tables from specific users, for example:
I have a schema called MainSchema and within that schema, i have a table called StageTable and a view called TargetView. I have a user schema called UserSchema.
I want UserSchema to be able to select from and use MainSchema.TargetView but i don't want the user to know that MainSchema.StageTable exists (other than looking at the view code).
So i give select access for MainSchema.TargetView to UserSchema and i don't give UserSchema any access to MainSchema.StageTable.
The problem is when UserSchema logs into the DB using Toad, they see two objects; StageTable and TargetView. They can select data from TargetView which is good but in the browser view they still see StageTable and once they try and select from it they get "ORA-00942: table or view does not exist".
Is there any way to hide StageTable from showing up in the Toad schema browser for UserSchema?
Not 100% sure this is not a Toad issue as opposed to Oracle issue but i know you can hide columns in Oracle so i was hoping you could do the same for tables.
Thanks!
Oracle Version is Exadata 11.2.0.4.0