Oracle database authentication in VB

5 pts.
Tags:
Development
Oracle
Hullo every one. Am programming in VB6 and connecting to an oracle db. How can I get the database to authenticate users, maintain all the specified privileges in the database from my application? Thanx! Wana

Answer Wiki

Thanks. We'll let you know when a new response is added.

When you connect to the Oracle DB, you supply a userid and pwd. this is the user that is authenticated by Oracle and access privleges checked. If you are using a generic userid, then you have chosen to bypass Oracle security.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Samachar
    Hi, In my point of view you can do it in 2 ways. You have to ask user for the entry an user name and password using a modal dialog box. i) Pass the user name and the password to Oracle to connect to the database which has been specified the authentication level according to the user name and passwd field. ii) You can make several connections with different forms and after the question of user name and passwd in the first form you load the corresponding form to user.
    0 pointsBadges:
    report
  • Nmdbf57
    If you use a common userid/password for oracle login by all users, If connecting thru middle tier provision to pass another string parameter (the user from your vb screen login) have a table in the schema to validate this using an oracle stored procedure/package. Password encryption can also be done and managed as table column. see oracle doc. Otherwise go the named user route where every user has their own oracle userid. Grant data access to roles, give users those roles. See oracle manual on security for details.
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following