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

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why is pl sql used?

522


What is a loop in sql?

560


What does truncate mean in sql?

530


What is the non-clustered index in sql?

585


What is multiple partition?

535






what is recursive stored procedure? : Sql dba

524


How can we optimize a sql query?

571


What is triggering circuit?

590


How to set up sql*plus output format in oracle?

591


What is cursor explain with example?

547


Why join is faster than subquery?

595


what are the advantages and disadvantages of views in a database? : Sql dba

527


What is the starting oracle error number? What is meant by forward declaration in functions?

536


Explain cursor types?

575


How do I upgrade sql?

542