Re: command for getting information on my schema

Chuck wrote:
>
> What SQL command or statement can I use to get information on my schema? For
> example, I want to review the configuration of Sequences I have created. I
> also want to know how various privileges are configured.
>
> Thanks,
> Chuck

Chunk,

Try "select * from dict where TABLE_NAME like 'USER%' " in sqlplus to get description for all USER views in data dictionary.

For example, query those views like "USER_SEQUENCES", "USER_COL_PRIVS",

"USER_COL_PRIVS_MADE", "USER_COL_PRIVS_RECD", "USER_ROLE_PRIVS",
"USER_SYS_PRIVS", "USER_TAB_PRIVS", "USER_TAB_PRIVS_MADE", and
"USER_TAB_PRIVS_RECD" to get what you want.

P.S. I use Oracle 8.0.5 on Solaris 2.5.

-- 
Leon L. Zhang
Email: lzhang1_at_lucent.com