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