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.."

Report message to a moderator

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: 21823
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.

Report message to a moderator

Previous Topic: Insertion/Retreival of a video into/from the database.
Next Topic: Copying files with PL/SQL
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Mar 10 14:41:45 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.