What is the difference between granting and creating a view?

Questions by umadevi   answers by umadevi

Showing Answers 1 - 5 of 5 Answers

Ramasamy PL

  • Jul 25th, 2006
 

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.   

  Was this answer useful?  Yes

ganne

  • Aug 1st, 2006
 

granting is dcl command

creating is ddl command

  Was this answer useful?  Yes

amahanit

  • Dec 1st, 2007
 

grand is to provide privilege on a specific object to a user

eg. grand select on emp to uma;

well view is a database object which is made from column of one or more tables.

if u don't have  sufficent privilege on other users object u can't access or modify it unless it's created by u.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions