OraFAQ Forum: SQL & PL/SQL » Know the users & listeners

Home » SQL & PL/SQL » SQL & PL/SQL » Know the users & listeners

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Know the users & listeners [message #8112]

Mon, 28 July 2003 00:47

Venugopalacharyulu kada
Messages: 13
Registered: February 2003

Junior Member

I have 2 doubts in oracle.

I just want, the SQL queries, to know all the ...

1) user names created manually in my system, but not the system created users at the time of installation.

2) listeners created manually in my system.

any body help me please.

Report message to a moderator

Re: Know the users & listeners [message #8201 is a reply to message #8112]

Sun, 03 August 2003 08:25

lajna
Messages: 8
Registered: June 2003

Junior Member

SQL> select * from all_users;

This query will give u ur first result.

Lajna

Report message to a moderator

Previous Topic:	Cursor FOR loop Problem
Next Topic:	constraints type

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 23 01:50:09 CDT 2024