I have a secure database that has users login using their oracle username/password. I've got that working great (thanks to some code I got off another thread....Thanks, Pat!), but I need to make it where my code automatically logs on a 2nd user, who has oracle access to a couple of linked tables. I've tried simply rerunning the "ConnectToOracle" function with the 2nd users's username and password, but the code doesn't do anything - an ODBC connection remains using the first user's login info, and a 2nd one is not created. So, I need to figure out a way to log the first user out (which would hopefully make the login work for the 2nd user), make the 2nd login overwrite the first one, or figure out a different way to do this.
The reason I need to do this is because my Access DB uses a linked oracle table. Different users are allowed to have access to different rows in this table. The code (and security) in my Access DB manages this side of it. This works fine as long as the user has access to the oracle table - but I don't want to give my users access to it as it would be a security breach. Instead, I have an Oracle user who has access to these tables that I would like to use as a 2nd login. After the user's oracle username and password are verfied, I would like to login the 2nd user as described above.
Does anyone have any ideas how to get this to work, or of another way of going around this?
The reason I need to do this is because my Access DB uses a linked oracle table. Different users are allowed to have access to different rows in this table. The code (and security) in my Access DB manages this side of it. This works fine as long as the user has access to the oracle table - but I don't want to give my users access to it as it would be a security breach. Instead, I have an Oracle user who has access to these tables that I would like to use as a 2nd login. After the user's oracle username and password are verfied, I would like to login the 2nd user as described above.
Does anyone have any ideas how to get this to work, or of another way of going around this?
