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

what is the difference between granting and creating a view?

Question Posted / swapna

Answers were Sorted based on User's Feedback



what is the difference between granting and creating a view?..

Answer / prasuna

Granting view means giving access to the view that is
already created where as creating a view means creating a
new view
granting privileges to a view is a dcl command
where as creating a view is a ddl command

Is This Answer Correct ?    4 Yes 0 No

what is the difference between granting and creating a view?..

Answer / swapna

Granting depends upon the user, he may give permission for
others to manipulation on the table. But in case of views
others can only retrive the table.
granting is dcl command
creating is ddl command

Is This Answer Correct ?    1 Yes 1 No

Post New Answer

More SQL PLSQL Interview Questions

How does sql developer connect to oracle database?

0 Answers  

What is pl sql and why it is used for?

0 Answers  

Why do we need sharding?

0 Answers  

What are code pages ?

1 Answers   BirlaSoft,

What are Anti joins

1 Answers   IBM,

What is data control language?

0 Answers  

Who is the owner of mysql database?

0 Answers  

hi this is nakka i have been looking for 1+ exp in oracle sql,plsql developer positions also have knoledge on d2k i am not getting proper walkins how to know it? where can i find it?

5 Answers  

What is Primary Key?

4 Answers   Ramco,

What is difference between stored procedure and trigger?

0 Answers  

what is timestamp in mysql? : Sql dba

0 Answers  

What is a null value?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories