Re: How to check Table's Owner
From: Leng Kaing <leng_at_cougar.vut.edu.au>
Date: 1995/12/14
Message-ID: <4ap5ev$8o3_at_cougar.vut.edu.au>#1/1
Date: 1995/12/14
Message-ID: <4ap5ev$8o3_at_cougar.vut.edu.au>#1/1
Walter Chow (wchow_at_sfsu.edu) wrote:
: Is there a way that I can check who is the owner of a
: table? Thank you very much.
Look at dba_segments.
eg: select owner from dba_segments where segment_name = 'DEPT' and segment_type = 'TABLE';
This gives you all owners of the DEPT table.
Leng. Received on Thu Dec 14 1995 - 00:00:00 CET