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

Which command is used to delete a package?

773


Enlist some predefined exceptions?

797


What is on delete set null?

766


how to use in conditions? : Sql dba

693


What is record variable?

708






how to enter characters as hex numbers? : Sql dba

748


Define a temp table?

755


what is the difference between clustered and non clustered index in sql? : Sql dba

737


what is the difference between char and varchar data types? : Sql dba

741


How delete all data from table in sql?

754


What is sql comments?

813


what are the security recommendations while using mysql? : Sql dba

769


What is difference between left and right outer join?

722


Describe sql comments?

728


What are the different sql commands?

724