Hide a particular table name of our schema in SQL
How can I hide a particular table name of our schema?
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Shankar MPosted Dec 1, 2012, 12:03 AM
There is no such way to hide table names in oracle sql. The only way is to create alternative names for database objects usually called Synonyms in Oracle.
To list all the tables for a particular use in Oracle SQL, we query the user_tables dictionary like,
SELECT *
FROM USER_TABLES;
Even, when you create the synonym for a table, the table does not go hidden.
Thanks,
Shankar
Satyapriya NayakPosted Nov 24, 2012, 2:34 AM
Example:
you can create a synonym y for table x
create synonym y for x;