Note that the owner of the table is the authorization id of the schema
containing the table. That is, the following query should show you who
owns what tables
select s.authorizationID, s.schemaName, t.tableName
from sys.sysschemas s, sys.systables t
where t.schemaID = s.schemaID
I haven't looked closely at how the ij introspection statements are
implemented. The original goal of ij was for it to be as
database-agnostic as possible. That is, the goal was to be able to
deploy ij against any database which has a JDBC driver (and therefore
access to a DatabaseMetaData object). I don't see authorization
identifiers modelled in the JDK 8 DatabaseMetaData.
Thanks,
-Rick
On 8/3/16, 2:21 PM, Bryan Pendleton wrote:
On 8/3/2016 4:57 AM, dulanja mallikarachchi wrote:
Hi all,
I want to list the tables created by me.
I don't think Derby keeps track of which table was created by which user.
Is there something that makes you think Derby is keeping track of that?
Derby *does* keep track of the *database* owner, but that's a different
concept, and applies to the database as a whole, not to individual
schema objects.
So far as I know.
thanks,
bryan
