Home » SQL & PL/SQL » SQL & PL/SQL » getting a list of current users
getting a list of current users [message #2591] Tue, 30 July 2002 01:27 Go to next message
Mark Grimshaw
Messages: 73
Registered: June 2002
Member
Hi,

I am trying to reduce code duplication in a package of stored procedures relating to user maintainence. I want to create a (reusable) procedure that will simply check if a user exists in the dba and throw an exception back up to a caller procedure if they don't exists. What SQL statement is there to check if a user exists?

Thank you

Mark

Report message to a moderator

Re: getting a list of current users [message #2595 is a reply to message #2591] Tue, 30 July 2002 06:33 Go to previous message
Silpa
Messages: 23
Registered: July 2002
Junior Member
select * from dba_users;

Report message to a moderator

Previous Topic: Difficult query!!!
Next Topic: PLEZE Solve this problem
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Apr 16 05:47:35 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.