Re: command for getting information on my schema

Hi Chuck,

Try selecting from the USER_SEQUENCES view to get information on sequences you have created..as for privileges try this (substitute 'DBA' where I have put 'USER' if it's appropriate):

select table_name from dict
where table_name like'USER%PRIVS%';

To list all of the data dictionary views available you can type:

select table_name from dict;

Just use a WHERE clause to shorten the list to what you want..

Have fun!

Steve

In article <930hgc$nf4$1_at_nntp6.u.washington.edu>,   "Chuck" <cabenson_at_u.washington.edu> 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
>
>

Sent via Deja.com
http://www.deja.com/ Received on Thu Jan 04 2001 - 11:51:55 CST