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 |
How do I enable sql encryption?
What are functions in sql?
How do I run a script in sql developer?
how to get a list of all tables in a database? : Sql dba
How do you explain an index number?
What is count * in sql?
What is meant by Join? What are the different types of Joins available? Explain.
how to sort records in sql?
write a query to find 4th max salary
in table there r so many rows write a query which two rows r updated last two day befor?
Differences between UNIQUE and DISTINCT in select statements
26 Answers ABS, DELL, Deloitte, Hewitt, Oracle, Verinon Technology Solutions, Wipro,
When is the explicit cursor used ?
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)