View Single Post
  #1 (permalink)  
Old 11-17-02, 02:20
abhijitbhosale abhijitbhosale is offline
Registered User
 
Join Date: May 2002
Posts: 7
Database creator name

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
Reply With Quote