How would you hide a table in sql. ie the table can be only visible to its mak

How would you hide a table in sql. ie the table can be only
visible to its maker?

Question Posted / swapna

3 Answers
10292 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How would you hide a table in sql. ie the table can be only visible to its maker?..

Answer / sa123

Dont create any public synonym, then that is available only
for its owner

Is This Answer Correct ?

7 Yes

4 No

How would you hide a table in sql. ie the table can be only visible to its maker?..

Answer / ankush

dont give any grant permission for the table except the
schema where the table is actually crearted.U can also use
a private synonym.. with in the schema to recognizing the
table with a dirrerent name.

Is This Answer Correct ?

0 Yes

0 No

How would you hide a table in sql. ie the table can be only visible to its maker?..

Answer / swapna

Once table is created in your own schema that is only
visible to that schema. For others it is not visible.

Is This Answer Correct ?

5 Yes

8 No

Post New Answer