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...

what is the difference between granting and creating a view?

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

What are different types of functions in sql?

1006


Can I create table without primary key?

1002


What is Histogram?

1564


Can we create view in stored procedure?

979


How do I send sql query results to excel?

1070


what are the performance and scalability characteristics of mysql? : Sql dba

999


Is left join faster than inner join?

1128


What is group function in sql?

1026


What is the purpose of using pl/sql?

1147


What is acid property in a database?

1035


What is record type in pl sql?

999


what is datawarehouse? : Sql dba

1024


How to test for null values?

1056


what is cursor. write example of it. What are the attributes of cursor.

1395


How do I count records in sql?

1014