Re: Update Oracle passwords through MS Access

In article <3p8qn3$qku_at_news.pacifier.com>, Rich Rankin <pukybear_at_pacifier.com> wrote:
>Is there a way for users to update their Oracle password in an Access
>application? Users are not allowed a Unix login or any other access to
>Oracle except through MS Access.
>Rich
>pukybear_at_pacifier.com
>Pacifier Online Data Service Dialup SLIP/PPP User
>To register: (360) 693-0325 or telnet pods.pacifier.com
To answer this question, we need to answer the question how does an user change his password in Oracle? The answer is by having the "Data Control Language" Oracle SQL construct
alter user foo identified by foo;
Now to answer your main question, Is it possible to do this via MS-ACCESS? The answer is no. Why? MS-ACCESS does not support this language construct. Basically MS-ACCESS-Oracle works like this. You have ODBC and SQL*Net on your windows client and SQL*Net on your server. ODBC is the binder. ODBC meaning Open DataBase Connectivity takes your query on the client, funnels them to the ODBC. ODBC talks to SQL*Net on the client and SQL*Net on the client talks to the server gets the data and funnels them back. So if MS-ACCESS support alter user then this should be possible.... Hope this helps.

Thanks
Mahesh Vallampati

Home:				   Office:
PH : 409 846 3794 (H)		|  409 862 1070 (O)
e-mail address  : oracle7_at_tamu.edu
WWW 		: http://tam2000.tamu.edu/~m0v5533/
Lab 		: 409 847 8609