Re: Create, Delete, View users in svrmgr

From: Eugene Firyago <>
Date: Mon, 24 May 1999 09:59:36 -0400
Message-ID: <7ibm24$2sg$>

To view database users:
select username from all_users;
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,

Darren Ko <> 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:
> Thanks very much,
> Darren Ko
Received on Mon May 24 1999 - 15:59:36 CEST

Original text of this message