RE: UNDER privilege?
- From: "Jim Silverman" <jsilverman@xxxxxxxxxxxxx>
- To: <cemail_219@xxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 27 Mar 2006 15:55:02 -0500
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@xxxxxxxxxxxxx -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of J. Dex Sent: Monday, March 27, 2006 3:45 PM To: oracle-l@xxxxxxxxxxxxx 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