Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Sv: NEWBIE How to get usernames...?
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
>
>
Received on Wed Jan 19 2000 - 03:44:49 CST