Re: Sv: NEWBIE How to get usernames...?

Because the password is stored in encrypted format, what you want to do is not easily possible...You can always try to connect as the user you want to check...

"Jens Fudge" <Jens.Fudge.lpt_at_indbakke.dk> wrote:

>Hi Marc
>
>Thank you very much for your help. There is however just a slight thing, I
>may have phrased my question, not so clearly..:-)
>I want to ask Oracle if User "Scott" is valid with Password "Tiger". With
>your solution I can only ask if Scott is a valid user.
>
>If you do know the answer I'd really appreciate a mail from you.
>Jens
>
>
>Marc Weinsock <MWeinstock_at_lds.com> skrev i en
>nyhedsmeddelelse:388481CB.128A60A7_at_lds.com...
>> dba_users tables tells all users that can access the db.
>> v$session tells what users are logged in at the moment.
>>
>> U can grant rights to these views to other users so they my have access.
>>
>>
>> Jens Fudge wrote:
>>
>> > Hi All
>> > I would like to know if the following scenario is possible, and HOW.
>> >
>> > If I'm a user on a Oracle database, and I need to ask the database if
>> > another user is valid on this same db, hoe do I do this:
>> > For instance I log on as Scott-Tiger, and I want to check if
>system-manager
>> > is a valid user on this table.
>> >
>> > Please reply directly at Jens.Fudge_at_lpt.dk as well as replying in the
>group.
>> > Thank you very much.
>> >
>> > Jens Fudge
>>
>> --
>> ===============================================
>> Marc Weinstock
>> Logical design Solutions
>>
>> 55 Broadway - 21st Floor
>> New York, New York 10006
>>
>> Phone: 800.221.5327 x2136
>> Fax: 212-825-2245
>> E-Mail: MWeinstock_at_lds.com
>> Web: http://www.lds.com
>>
>>
>

  -----------== Posted via Newsfeeds.Com, Uncensored Usenet News ==----------    http://www.newsfeeds.com The Largest Usenet Servers in the World! ------== Over 73,000 Newsgroups - Including Dedicated Binaries Servers ==----- Received on Wed Jan 19 2000 - 11:28:22 CST