Oracle database authentication in VB (Q/A)

Posted by NosaLee in Oracle, VB6 Programming on 06-06-2012. Tags: Oracle Database Experience, Oracle FAQ, Oracle Q & A, Oracle Skills, VB6 FAQ, VB6 Programming Experience, VB6 Q & A, VB6 Skills

Question by wanaug

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
____________________________________
Replied by costevet

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.
____________________________________
Replied by 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.
____________________________________
Replied by 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.

____________________________________
Original Address: http://itknowledgeexchange.techtarget.com/itanswers/oracle-database-authentication-in-vb/

(0) Comments