PL/SQL - what is the difference between granting and creating a view?

GeekInterview.com

I am new, Sign me up!

GeekInterview.com > Tech FAQs > PL/SQL

Go To First | Previous Question | Next Question

PL/SQL | Question 41 of 166

Print

what is the difference between granting and creating a view?

Total Answers and Comments: 5

Last Update: March 13, 2008 Asked by: umadevi

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

July 25, 2006 02:33:37

#1

Ramasamy PL

RE: what is the difference between granting and creati...

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.

Is this answer useful? Yes | No

August 01, 2006 08:00:09

#2

ganne

RE: what is the difference between granting and creati...

granting is dcl command

creating is ddl command

Is this answer useful? Yes | No

November 21, 2007 02:03:03

#3

Member Since: November 2007 Contribution: 26

RE: what is the difference between granting and creati...

Hi ganne!
GRANT IS NOT DCL COMMAND IT IS TCL COMMAND
Regards
NRK.

Is this answer useful? Yes | No

December 01, 2007 04:30:39

#4

Member Since: October 2007 Contribution: 13

RE: what is the difference between granting and creating a view?

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.

Is this answer useful? Yes | No

March 13, 2008 13:48:21

#5

Member Since: February 2007 Contribution: 38

RE: what is the difference between granting and creating a view?

GRANT and REVOKE are DCL commands ...

Is this answer useful? Yes | No

Sponsored Links

About Us - Privacy Policy - Terms and Conditions - Contact - Ask Question - Propose Category - Site Updates

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved