Forms :: Connect Using Proxy User
Mar 29, 2012
We had a database NSSAPP4d with only one schema say A , but now requirement is we will have two schemas in NSSAPP4d with existing schema A and new B, now both these schemas have same tables except few.
In Schema 'A' all objects had Public Synonyms which needs to be removed and instead have Private synonyms in both Schemas A & B.We will have a proxy user for which all Private synonyms for all objects will be created.
I have created a proxy user e.g. MJ_TEST_PROXY with necessary privileges.I have created other user MJ_TEST with necessary privileges.Now I am running below script
ALTER USER mj_test_proxy grant connect through mj_test with role <all roles of mj_test_proxy>
If I connect as mj_test/mj_test@NSSAPP4d then I get ORA-04067 Error.When try to connect through fron-end(forms) I need to give mj_test[mj_test_proxy]/mj_test$NSSAPP4d
I want to avoid giving proxy name , but want to connect thorough proxy.
View 18 Replies
ADVERTISEMENT
Nov 15, 2010
I created an externally authenticated user in database. And can login without password with below syntax.
SQL> connect / @TESTDB
Connected.
SQL> show user;
USER is "SCOTT"
This scott user has a proxy permission to another DBuser PROXY_USER. Previously I used to login using below syntax.
connect scott[proxy_user]/password_for_scott@TESTDB
So now, what syntax should be used for this "ExternallY Authenticated" user to login as a proxy user?
View 10 Replies
View Related
Jul 14, 2010
I am suffering for a week over a problem in Forms and can not solve it. This problem: [URL] The main part where "reqest.getRemoteAddr()"
View 14 Replies
View Related
Mar 6, 2013
created one user and granted connect, resource.
SQL> create user xyz identified by welcome123;
but while connecting to that user it's not connecting. saying
SQL> conn xyz/welcome123
ERROR:
ORA-01017: invalid username/password; logon denied
Warning: You are no longer connected to ORACLE.
SQL>
but i am sure i create user.i though to drop and recreate that user. But it is saying connected user can't be drop.then i checked for the connected session of xyz user. but shocked, there is no session for xyz user.
View 7 Replies
View Related
Nov 8, 2011
I like to know how to insert/select a table from a user to other user.
e.g. :
if i give this below command the data is not inserting.
INSERT INTO MYDATABASE.MYTABLE Select * from MYTABLE where YEAR = '2011'
OR
SELECT * FROM MYTABLE@MYDATABASE WHERE YEAR = '2011'
if i execute the above commands i get the error: Table or view does not exist
Connection to remote database not found
I have made a database link to that database but its not working.
View 1 Replies
View Related
Sep 14, 2012
I have written a trigger as below:
CREATE OR REPLACE TRIGGER LOGONTRIG
AFTER LOGON ON DATABASE
DECLARE
v_temp NUMBER;
V_bypass_trg_flag VARCHAR2(1);
[code],...
This trigger got successfully compiled. and when am trying to connect to the db with other user its giving me error "ora-06512 : at dbms_session".When i grant dba privillage to that user am successfully able to login to db.
View 2 Replies
View Related
Oct 19, 2012
last two years i am using oracle 9i in windows 2003 server but now i installed oracle 10g on another server (PC) , i want to connect 9i to 10g with same database and user .
View 3 Replies
View Related
Dec 5, 2012
I'm trying to create a web service via the WSDL wizard (Apex 4.0.2). We are behind a firewall and connect to the internet via a proxy server. The proxy server requires authentication with a username and password. How to include the username and password in defining the Proxy Server in the Application Definition page or optionally in the alternate location in the Manual Web Service wizard page?
I assume the base definition for the proxy server is [http://]host[:port][]
View 2 Replies
View Related
Jun 4, 2012
> id -a
uid=56088(appadm) gid=50120(dba) groups=50120(dba)
> sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Mon Jun 4 09:26:23 2012
Copyright (c) 1982, 2005, Oracle. All rights reserved.
ERROR:
ORA-12545: Connect failed because target host or object does not exist
Enter user-name: ^C
our UNIX user in group "dba" but can't connect as SYS
why?
View 9 Replies
View Related
Jul 22, 2012
I have migrated my database to oracle and while migration i have followed all instructions and migrated to oracle.the connection and user having my tables and all object is
con name: orcltestcon user: orcltestuser and password: orcltestuser.
I want to turn on ARCHIVELOG Mode ON.
1) Is it good practice to turn on archivelog. also tel me cases where it is good.
2) to turn on ARCHIVELOG , with which command i should connect.
1) CONNECT SYS/<password> AS SYSDBA;
or
2) CONNECT orcltestuser/orcletestuser AS SYSDBA.
View 1 Replies
View Related
Aug 22, 2012
I'm getting the error below when downloading IR report in csv format. I'm getting that whenever the records is more than 108,000. Is there a limit in records to download? Is there a resolution.
I am using apex 4.1, EXCEL 2010.
View 6 Replies
View Related
Mar 23, 2013
How to overcome the prompt user id & password to connect oracle DB from Unix environment.
View 2 Replies
View Related
May 15, 2013
For auditing, I need to insert the user, among other data, into different tables. The thing is, I have an application with DB account authentication, so a real database user is connected, when auditing, the user field inserted is "ANONYMOUS".
Apex 4.2
EPG
Oracle Enterprise Linux 5.5
Database 11.2 EE
View 7 Replies
View Related
May 28, 2011
how can i assign permissions to one user to add,delete,edit data and other user should be able to perform all functions or selected functions
View 12 Replies
View Related
Oct 20, 2012
- we have user id parameter.can we update the parameter(:parameter.p_userid) before firing "WHEN NEW FORM INSTANCE TRIGGER"(when new form instance trigger contain code for tree node), for login another canvas as per user rights?
- i have created a login form in one canvas.
- also tree node Hierarchy form created on another canvas. now we want to login through login screen, after login only those forms should show in tree Hierarchy which users have rights. for this purpose we want to pass the parameter of userid before connecting to tree node form through the following query
SELECT COUNT (*)
INTO v_count
FROM usersinfo
WHERE usersname = :USERBLOCK.usernames AND passwords = :USERBLOCK.passwords ;
[code]...
Every thing is working but when we click on button in login form at that time parameter.p_userid will return null. because above code is define on button click in login screen, i cannot understand where i need to define the above code .
View 1 Replies
View Related
Feb 25, 2010
Is it possible to connect SQL Server 2000 with Forms6i?
View 1 Replies
View Related
Jul 18, 2011
while new form open i need to connect the data base.
View 5 Replies
View Related
Aug 26, 2010
How can I connect forms6i to run on SQL database ?
View 4 Replies
View Related
Jul 7, 2012
I have been troubling with this issue for the last two weeks...tried so much, but could not able to resolve....
sqlplus username/password@IPAddress:port/ServiceName
I am able to connect to DATABASE from SQLAssistant only when I provide string like ABOVE........If I dont mention the SERVICE, m unable to connect to DB.Now the biggest issue is with SQL Developer.....m not at all able to connect to DB using SQL Developer.
View 3 Replies
View Related
Aug 17, 2010
I have installed oracle developer 6i. in sqlplus i want to put my username and password but nothing in the connect string field.
View 1 Replies
View Related
Oct 6, 2010
I have the following computer/setup:
Acer laptop, Intel Processor w/ Windows 7 Professional (64-bit)
Delphi 2010 Professional
Oracle XE (+ the Oracle XE client that comes with it)
I cannot can't to the Oracle database from Delphi. The error I keep getting is:
Alias is not currently opened. [Oracle][ODBC][Ora]ORA-12154:TNS: could not resolve the connet identifier specified.
Here's what I've done:
1. Create an ODBC connection to my Oracle database
- run C:WindowsSysWOW64odbcad32.exe to open the ODBC administrator.
- Data source name: bt_user
- TNS Server Name: localhost/xe
- user bt_user
- Clicked "test connection" -- Success.
2. Open Delphi and drop a TDatabase component on my main form.
- Set the Alias Name property to "bt_user" (the alias I set up in ODBC)
- Set database name to "bt_user".
- Checked "connected".
Alternatively, I tried using the Delphi ADO components (the dbGo components).
- Drop TADOConnection component on my form.
- Select "connection string" and open the dialog.
- Click "build string".
- Select "Microsoft OLE DB Provider for ODBC Drivers" from the selection.
- In "use data source", select "bt_user" from the drop-down list (my ODBC connection from #1)
- Click "test connection".
Again the same error.
My questions are:
1. Can Delphi work with Oracle XE (Express Edition)?
2. If so, then do I need to install the "Instant Client"?
3. Will the instant client for Oracle 10g work with Oracle 10g XE?
4. Do I need to install any additional ODBC driver(s)?
5. Why was I successful in creating the ODBC connection in Windows, but it failed in Delphi?
6. Will Visual Studio.NET (C#) work with Oracle XE, and what are the steps for setting that up?
View 2 Replies
View Related
Dec 25, 2011
when a user change or delete any record or row in forms data automatically move to other table because i want to compare old and new record.
View 8 Replies
View Related
Sep 3, 2009
I installed oracle 10g and developed simple software using forms 6i. Its working well as a stand alone system.
I want to share it in network. so I installed forms 6i as oracle client , copied the tnsnames.ora from the oracle installation path to forms installation path.(inside NET80/Admin folder)
When i try to connect with user name and password , it comes ORA-12203 Unable to connect to destination. I checked LSNRCTL in the database machine, it is listening.
View 11 Replies
View Related
Oct 2, 2007
I m using Oracle Forms 6i and Oracle 10g Express Edition. I am having the following error message when I am trying to connect to the database from client.I have dont following configuration in my client's FORM's TNSNAMES.ORA file.
0001 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = bankvigil)(PORT = 1521))
(CONNECT_DATA = (SID = XE))
)
In the above configuration
0001 = my connect string.
BankVigil = My Oracle database server hostname.
View 9 Replies
View Related
Apr 6, 2011
In my application i need connect different databases from a form. How can i do that?
View 4 Replies
View Related
Jun 4, 2011
i got static ip from witribe a broadband company in pakistan i am trying to connect database from client side computer who connect with internet when i ping my server it reply with good speed but when i try to connect database the message appear (Unable to connect Destination) but it works very well with Local Area Network computers. More how can we change port 1521 in client sides
View 6 Replies
View Related
May 27, 2010
I am install the forms11g and database10gr1 , now when you open the form and write in login ( scott/tiger@orcl ) thise message is show
ORA-12154: TNS: could not resolve the connect identifier specified.
how to connect database10g to Form11g.....
I cant find the net configuration assistant same form10g .....
View 27 Replies
View Related
Sep 24, 2010
I just want to know whether Oracle forms 11g supports other databases like DB2, SQL Server etc.
Also does Oracle forms 11g supports Oracle database 9i or 10g apart from 11g?
View 1 Replies
View Related
Oct 15, 2010
I have a pb went i can access on my forms server:
FRM-92050: Failed to connect to the Server: ://127.0.0.1/servlet/oracle.form...enerServlet:-1
java.net.ConnectException: Connection refused
View 1 Replies
View Related
Jan 20, 2012
I have DevSuite 10g on my XP. Running a form from frombuilder, for testing or debugging purposes for example, always worked. I am using OC4J.Now we moved the DB-User, to which I normally connected in the above scenario, to another DB-Instance, but left username and password unchanged. I changed my connection in formbuilder to the new destination and formbuilder succeeds when connecting to the DB. Compile etc. all ok.But running a form from formbuilder raises ORA-01017. After that, the forms logon screen is shown and has exctly the username and ORACLE-SID defaulted with my connection in formbuilder itself (only username is "upper"ed).
So apparently the formbuilder connection information or oarts of it is passed to the runtime. When I then give the password in the logon screen connecting succeeds. How is the connect information from formbuilder passed to the runtime?
View 4 Replies
View Related
