Re: How to check Table's Owner
From: Jim Deeming <jwdxt_at_boco.co.gov>
Date: 1995/12/12
Message-ID: <4aju45$ja5_at_news-1.boco.co.gov>#1/1
Date: 1995/12/12
Message-ID: <4aju45$ja5_at_news-1.boco.co.gov>#1/1
Walter Chow (wchow_at_sfsu.edu) wrote:
>Hi,
>Is there a way that I can check who is the owner of a
>table? Thank you very much.
select table_name, owner from dba_tables;
Appendix B of the Administrator's Guide contains the Data Dictionary Reference which has all kinds of useful information like this.
Jim Deeming Received on Tue Dec 12 1995 - 00:00:00 CET