Home » Developer & Programmer » Forms » How To change user database in form
icon4.gif  How To change user database in form [message #272325] Thu, 04 October 2007 10:20 Go to next message
oriental
Messages: 8
Registered: October 2007
Location: Bandung
Junior Member
Pleas how to change user, password and database in form, so i can select table from new user password and database.

There is always error "..not declare.."
Re: How To change user database in form [message #272375 is a reply to message #272325] Thu, 04 October 2007 15:43 Go to previous message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Where's the purpose in logging in as one user, and then - in the middle of a form - logout and connect as another user?

I'd rather do something else. For example, GRANT required privileges from one user to another and reference tables/views/whatever using the 'schema.object_name' notation. Or, to avoid it, you might create a SYNONYM and leave all your queries as they were.
Previous Topic: Insertion/Retreival of a video into/from the database.
Next Topic: Copying files with PL/SQL
Goto Forum:
  


Current Time: Sat Dec 03 14:24:22 CST 2016

Total time taken to generate the page: 0.09482 seconds