Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

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

Question Posted / swapna

Answers were Sorted based on User's Feedback



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

Answer / sa123

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

Is This Answer Correct ?    7 Yes 4 No

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

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

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

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

Post New Answer

More SQL PLSQL Interview Questions

How do you change a value in sql?

0 Answers  

What is the difference between RDBMS and DBMS?

20 Answers   Practical Viva Questions, Sapient, Stag Computers,

What is the non-clustered index in sql?

0 Answers  

Why trigger is used in sql?

0 Answers  

what is a database transaction? : Sql dba

0 Answers  

What is the difference between inner join and outer join?

0 Answers  

difference between cursor and procedure in a package

3 Answers   PCS,

Explain what is sql*plus?

0 Answers  

Which command is used to delete a package?

0 Answers  

Can a table contain multiple foreign key’s?

0 Answers  

I Have A Table Like This. Cityno Cityname Mails 1 Bangalore 8km 2 Hsr Layout 20km 3 Mejistic 30km 4 Jayadeva 55km 5 Itpl 80km 6 Hebbal 115km I Have Data Like This I Want O/p Like This Distance No.ofcity 0-50km 3 51-100km 2 101-150km 4 And So On

6 Answers   DELL, HCL, Oracle,

In a distributed database system, can we execute two queries simultaneously?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories