Mamta, Derby currently doesn't have object owner as part of object descriptors in the system catalog. While it would be great to add authorizationID to object descriptors at some point, it doesn't help much at this time. This is because Derby doesn't have a way to grant ability to others to create objects in owner's schema. Derby is missing other part of Grant/Revoke work, system privileges. Until that work is complete, Derby's schema owner owns all objects in that schema. So you could just get routine's owner name from its schema descriptor.
Satheesh Mamta Satoor wrote: > Hi, > > In order to implement EXTERNAL SECURITY DEFINER on a routine, I need > to know the creator/definer of the routine. Is there a system > table where we save this information? If not, it seems like, > SYSALIASES may be the right place to put this information in. > > thanks, > Mamta
