Hide a particular table name of our schema in SQL

Question

How can I hide a particular table name of our schema?

Shankar M · Answer

Hi Sharad 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 Nayak · Answer

You can hide the table name of your schema by creating synonyms. Example: you can create a synonym y for table x create synonym y for x;