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

Answer Posted / sa123

Dont create any public synonym, then that is available only
for its owner

Is This Answer Correct ?    7 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?

2762


What is localdb mssqllocaldb?

803


What is output spooling in sql*plus?

743


What is use of trigger?

677


Can a table have no primary key?

775






What is oracle sql called?

675


How do I audit the sql sent to the server?

732


First round ------------------- - Procedure - Packages - Views - Virtual tables - Can we use dcl with in function? - Joins and few scenarios - Triggers and its type - Pragma, type and its functionality - How to create db link in oracle - Materialized view - How to find duplicate values from table? - Cursor and its functionality - Write a script to display friday and its date from a entire year. - Exception Handling Second round ------------------------ Gave a scenario like. Need to write a function to perform. When user try to change a password. It must not be last five password and a given password can be combination of characters, symbols, upper and lower case.

1336


What are pl sql data types?

726


what is 'trigger' in sql? : Sql dba

726


Is pl sql and postgresql same?

769


Is sql a case sensitive language?

706


State few characteristics of pl/sql?

727


What is auto increment?

733


What is an implicit commit?

762