How would you hide a table in sql. ie the table can be only
visible to its maker?
Answers were Sorted based on User's Feedback
Answer / sa123
Dont create any public synonym, then that is available only
for its owner
Is This Answer Correct ? | 7 Yes | 4 No |
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 |
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 |
What does select count (*) mean in sql?
What is pl sql record in oracle?
How toimport .dmp file in lower version of oracle from higher version ?
What is difference between hql and native sql?
How to create a menu in sqlplus or pl/sql?
how to shutdown mysql server? : Sql dba
How do I run sql profiler?
What is primary key in db?
How can we debug in PL/SQL?
How to check if a column is nullable before setting to nullable?
what is a database? : Sql dba
Explain the advantages and disadvantages of stored procedure?