Though I'm not 100% sure, looks like you are on the right track with SYSVERSIONS catalog table ...
I have checked over 15 databases which I have access over and they seem to be pointing towards your assumption
Cheers
Sathyaram
Quote:
Originally posted by abhijitbhosale
Hi I want to find out the name of the database creator or owner.
One way I tried is following query
"SELECT grantee FROM syscat.dbauth WHERE grantor='SYSIBM' and dbadmauth='Y' "
But sometimes it returns more than one users.
So this query is not returing correct owners.
I found that sysibm.sysversions contains AUTHID column.
Is it the name of the database creator or owner?
Thanks,
Abhijit
|