Home » SQL & PL/SQL » SQL & PL/SQL » User Authentication by SQL Queries ???
User Authentication by SQL Queries ??? [message #440] Tue, 12 February 2002 12:08 Go to next message
Sal wheelar
Messages: 3
Registered: February 2002
Junior Member
Can I authenticate database user without connecting to database by passing userid and password.

Suppose I have connected to database as User1.
Can I issue queries with userid and passwords as parameters of other users to check whether they are valid users.

Report message to a moderator

Re: User Authentication by SQL Queries ??? [message #447 is a reply to message #440] Wed, 13 February 2002 00:56 Go to previous message
pratap kumar tripathy
Messages: 660
Registered: January 2002
Senior Member
hi,

u can see if the user exist or not by looking at dba_users or all_users views .i don't think u can pass password and authenticate.

cheers
pratap

Report message to a moderator

Previous Topic: difficulty Framing a query
Next Topic: Sequence problem - URGENT!!
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 19 15:15:36 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.