RE: UNDER privilege?

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

Other related posts: