Re: HELP NEWBIE: listing of users objects with sql

dgc_at_usa.net wrote (in <6ggevq$im9$1_at_nnrp1.dejanews.com>)...

| Trying to do the following:
| Create a script that reports on all objects owned by a specific user.
| The username is a parameter. The report includes object_type, object_name
| , when it was created and status.
|
| I would be really thankful if someone could help me.
|
|
| dgc_at_usa.net
|
| -----== Posted via Deja News, The Leader in Internet Discussion ==-----
| http://www.dejanews.com/ Now offering spam-free web-based newsreading
Hello,
  log onto SQL*Plus and execute the following commands:

column comments format a70 trunc;
set linesize 130;
set pagesize 45;
spool dict.lis

select table_name, comments from dictionary order by table_name
/

spool off;
exit

You now have a useful list of dictionary objects and their contents.

If you start to examine them using the 'describe' command then it should be fairly easy to get the information you need for your 'objects owned by a user' query.

Paramters to SQL*Plus scripts:

'&1' is the name of the first substitution parameter on the command line, '&2' is the second parameter... etc.

graham Received on Wed Apr 08 1998 - 14:17:06 CDT