VIEW: SYS.USABLE_EDITIONS

Source

View Text - Preformatted

select o.name, po.name
from sys.obj$ o, sys.edition$ e, sys.obj$ po
where o.obj# = e.obj#
  and po.obj# (+)= e.p_obj#
  and bitand(e.flags,1) = 0
  and (o.owner# = userenv('SCHEMAID')
       or o.obj# in (select obj#
                     from sys.objauth$
                     where grantee# in ( select kzsrorol
                                         from x$kzsro
                                       )
                    )
       or /* All users have implicit USE priv on the db default edition */
         o.name = (select property_value
                   from database_properties
                   where property_name = 'DEFAULT_EDITION')
      )

View Text - HTML Formatted

SELECT O.NAME
, PO.NAME FROM SYS.OBJ$ O
, SYS.EDITION$ E
, SYS.OBJ$ PO WHERE O.OBJ# = E.OBJ#
AND PO.OBJ# (+)= E.P_OBJ#
AND BITAND(E.FLAGS
, 1) = 0
AND (O.OWNER# = USERENV('SCHEMAID') OR O.OBJ# IN (SELECT OBJ#
FROM SYS.OBJAUTH$
WHERE GRANTEE# IN ( SELECT KZSROROL
FROM X$KZSRO ) ) OR /* ALL USERS HAVE IMPLICIT USE PRIV ON THE DB DEFAULT EDITION */ O.NAME = (SELECT PROPERTY_VALUE
FROM DATABASE_PROPERTIES
WHERE PROPERTY_NAME = 'DEFAULT_EDITION') )