Re: Create, Delete, View users in svrmgr

To view database users:
select username from all_users;
or
select username from dba_users;

To delete an user specified by user_name: drop user user_name cascade;
(be careful dropping users! :-)

To view a table/view structure from within SQL*Plus: describe table_name;
describe view_name;

You could find the Oracle Doc Library (either in pdf or html format) on your Oracle installation CD or on the special media naming "On-Line Generic Documentation CD" usually shipped along with the Oracle Server installation CD.

Good Luck,
Eugene.

Darren Ko <darren.ko_at_admarketing.com.hk> wrote in message news:37495449.42983759_at_202.76.1.2...
> Greetings,
>
> I'm currently substituting for an Oracle DBA, and have just learned
> about creating an Oracle User:
>
> SVRMGR> connect system/manager;
> SVRMGR> create user <user> identified by <password>;
> SVRMGR> grant connect to <user>;
>
> But I also need to know how to view and delete Oracle Users. I haven't
> touched Oracle before, so is there any on-line manuals I should be
> aware of? If not, can anyone kindly point out the procedures?
>
> Any suggestions are most appreciated. Please reply to:
> darren.ko_at_admarketing.com.hk.
>
> Thanks very much,
>
> Darren Ko
Received on Mon May 24 1999 - 08:59:36 CDT