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 is the requirement of self-join?
What is a primary key, and how is it different from a unique key?
What is record data type?
What is the order of sql select?
How do you write an index?
What is the difference between SQL Constraint and PL/SQL constraint.Pls give all the constraint name.
what is variable in package specification
Is full outer join same as cross join?
What are the basic sql commands?
Does pl/sql support create command?
Explain character-manipulation functions?
What is pls integer?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)