Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: UNDER privilege?

RE: UNDER privilege?

From: Jim Silverman <jsilverman_at_Solucient.com>
Date: Mon, 27 Mar 2006 15:55:02 -0500
Message-ID: <2D1EFB433A527D4681B80C94B71E3598044597DA@aaexchange01.HEALTH.AD>


While it would have been terribly easy to come up with some sort of answer based on the phase "UNDER PRIVILEGE", I checked the (10g) documentation and found the following in the Application Developers Guide in the discussion on Object Types and Methods:

                Schema Object Privileges

                Two schema object privileges apply to object types:

                EXECUTE on an object type enables you to use the type to:

				Define a table.
				Define a column in a relational table.
				Declare a variable or parameter of the
named type.

                EXECUTE lets you invoke the type's methods, including the constructor.

                Method execution and the associated permissions are the same as for stored PL/SQL procedures.

                UNDER enables you to create a subtype or subview under the type or view on which the privilege is granted

                The UNDER privilege on a subtype or subview can be granted only if the grantor has the UNDER privilege on the direct supertype or superview WITH GRANT OPTION.



Jim Silverman
Senior Systems Database Administrator
Solucient, LLC
Telephone: 734-669-7641
FAX:            734-930-7611
E-Mail:         jsilverman_at_solucient.com


-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of J. Dex Sent: Monday, March 27, 2006 3:45 PM
To: oracle-l_at_freelists.org
Subject: UNDER privilege?

Public has a privilege called "UNDER" on object URITYPE. Does anybody know
what the UNDER privilege is/does? I've never seen this one before.



Don't just search. Find. Check out the new MSN Search! http://search.msn.click-url.com/go/onm00200636ave/direct/01/

--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Mon Mar 27 2006 - 14:55:02 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US