3
Contributors
2
Replies
3
Views
7 Years
Discussion Span
Last Post by debasisdas
0

You mean you want to create several users for Oracle ? Use the connection string method given above and change the username and password as required. For example

For User1
ConnString = "Provider=MSDAORA.1 ; Password=myPassword1; User ID=myUser1 ; Data Source = ORCL; Persist Security Info=True"

For User2
ConnString = "Provider=MSDAORA.1 ; Password=myPassword2; User ID=myUser2 ; Data Source = ORCL; Persist Security Info=True"

etc.

0

what i understand is you need to store username and password in oracle database and use that credential to login to your application dynamically at runtime.
if that is the case

select count(*) from user_login where user_name='username' and password = 'password'

if this returns 1 then allow to log in to application else re-prompt for username and password.
NOTE:--Username must be the PK of the table storing the log in credentials.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.