| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Re: NEWBIE How to get usernames...?
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
--
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 Tue Jan 18 2000 - 09:07:15 CST
 |
 |