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 cursor explain with example?
What does pragma mean?
What is clustered index in sql?
How many commands are there in sql?
can we use out parameter in a function?Give an example.
What are the triggers associated with image items?
Give an example of Full Outer Join?
How much ram can sql express use?
What are the commands used in sql?
Is ms sql is free?
counting the no.of characters occurs in a string by using pl/sql function
Oracle (3253)
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)