db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dag.Wan...@Sun.COM (Dag H. Wanvik)
Subject Re: Wiki Page for dblook SQL Authorization Support Project
Date Thu, 14 May 2009 21:46:33 GMT

Thanks, Hiranya,

a small addition to my previous comment:

>> For example, for a view, the SYSVIEWS table contains a reference to
>> the owning schema in the column COMPILATIONSCHEMAID.  The system table
>> for schemas, SYSSCHEMAS, contains AUTHORIZATIONID for each
>> schema. This is the owning user user (since Derby does not yet support
>> a schema being owned by a role, although the SQL standard does allow
>> that). So joining COMPILATIONSCHEMAID with SYSSCHEMAS.SCHEMAID gives
>> the owning user of a view. The case is similar for triggers and
>> constraints.

and, of course, and tables and routines (the latter are found in
SYSALIASES).

Dag

Mime
View raw message