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?
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
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/