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
How many functions are there in sql?
Can we insert in sql function?
Can I copy :old and :new pseudo-records in/to an oracle stored procedure?
i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this
How to read xml file in oracle pl sql?
what is the difference between $message and $$message? : Sql dba
What are pl/sql cursor exceptions?
What does truncate mean in sql?
What are the constraints available in sql?
What do you understand by pl/sql cursors?
How many parts of a pl sql block are optional?
What is normalization in sql?
How do you modify a trigger?
What is crud sql?
What is sql and also describe types of sql statements?