Forms :: Change Password On Welcome Form

Nov 23, 2010

I am calling a form whose name is welcome from the menu module. Now there is a button "change password" on the welcome form and I want that when I call the welcome form automatically the change password button should be pressed and which in turn calls a new window for resetting of password.

I am calling the welcome form by using go_form('welcome');I tried this coding in the menu module.

go_form('welcome');
GO_ITEM('APP_VERSION.RESET_PASSWORD');
show_reset_password;
-----------------------------------
PROCEDURE show_reset_password IS
[code]....

View 2 Replies


ADVERTISEMENT

Forms :: Change Prompt Of Form With Another Name?

Jul 5, 2010

i want a procedure or any other way to change the prompt of a form with another nameand get the name from a table in database that table contain the old name ,, and the new name

i want to use this procedure to facilitate different language user to change the prompt of all item to the user language i have done one but it's not as good as i want i need it to work with a big sys with a lot of items and change all it;s prompt

all i have to do is to fill the table with the words only

View 2 Replies View Related

Forms :: Change Color In Fields In Form Filled Via Data Block?

Jan 4, 2012

I'm trying to change the attributes on a display where the info is gathered via a routine that fills the data block with info. I've searched and tried using 'set item instance property' in several places within the data block using different triggers but still doesn't work.

No errors are encountered or shown. Attributes aren't changed based on a small test condition.

View 2 Replies View Related

Change Root / Oracle Password In Rac

Mar 16, 2012

I need know the impact in my oracle database 10g R2, if i change root/oracle passwords in my Oracle RAC environment, my database using ASM and the nodes is in Red Hat 4.7.

View 1 Replies View Related

SQL & PL/SQL :: Change Password Without Using ALTER Statement?

Aug 9, 2010

Requirement: I need to create a Function to allow users to change their own password when they are logging in to an application. Also, I would prefer to not use the ALTER command.

View 12 Replies View Related

Security :: Logminer And Password Change?

Oct 15, 2010

Is it possible to track the password changes made by some user using the logminer with the archived logs?

View 1 Replies View Related

Unable To Connect OE Once Change Sys Password

Jan 7, 2013

some days ago we chaged sys,system and sysman password using SQL console. ORACLE 10.2.0.1.0 Now Backups and SQL console loggins are ok but we cant connect OEM console having: insufficient privileges, logging as sys / as sysdba

we reload (start / stop) oem console service and now the OM page is unable to be desplayed having (when starts finished no error messages was found):

The webpage cannot be found

or

Enterprise Manager is not able to connect to the database instance. The state of the components are listed below.

but all is OK !!The DB SO is linux unbrekeable.

View 2 Replies View Related

SQL & PL/SQL :: How To Change User Password In Stored Procedure

Sep 9, 2010

OBJECTIVE: To allow a user to change their own password after logging into an application.

BACKGROUND: I have a stored procedure where I pass the userid, old password, and new password. The stored procedure contains the following ALTER statement:

EXECUTE IMMEDIATE 'ALTER USER :uid
IDENTIFIED BY :npwd REPLACE :opwd'
USING IN v_user_id, v_new_pwd, v_old_pwd;

where v_user_id, v_new_pwd, and v_old_pwd are the arguments passed to the stored procedure.

FACTS:
(1) The procedure compiles fine;
(2) During execution, SQLCODE returns "0" (i.e. zero);
(3) My userid does have permission to change my password and execute the stored procedure;
(4) At the time I call the stored procedure, I am successfully logged into the application with my userid and old password.

PROBLEM: When I try to login with the new password I get the following error: "ORA-01017 invalid username/password; logon denied".

View 12 Replies View Related

SQL & PL/SQL :: Using EXECUTE IMMEDIATE For DDL Command In Procedure For Password Change?

Nov 6, 2011

I have a procedure in this procedure i use.

EXECUTE IMMEDIATE 'alter user '||use||' identified by '||modp ||' replace '||oldp;

but when i execute it show insufficient privilages but i create for this procedure as public.and grant execute facility to the user.

View 6 Replies View Related

Security :: User Unable To Change Password With Command

Aug 23, 2010

We have enable the alter log for audit purpose so the password will be display in the log which is not security. I try to use "password" to change password but very user got the error below.

SQL> password
Changing password for RUDEE
Old password:
New password:
Retype new password:
ERROR:
ORA-00604: error occurred at recursive SQL level 1
ORA-20014: -6502 ORA-06502: PL/SQL: numeric or value error
ORA-06512: at line 27

Password unchanged

View 17 Replies View Related

Security :: ORA-20007 - Change User Account Password

Jul 16, 2011

When i try to change the user account password, i get following error.

alter user bala
identified by Ju4hlsd2;

ERROR at line 1:
ORA-20178: ORA-20176: ORA-28003: password verification for the specified password failed
ORA-20007: Password cannot consist of sequences of 3+ characters from the userid

how to set the password based on the error.

View 5 Replies View Related

Unable To Change Password In SQLPLUS After Trigger Added

Aug 17, 2012

One of my Customer had followed the document applied pertaining to mitigate against vulnerability CVE-2012-3132.

New Document Mitigation steps for CVE-2012-3132 [ID 1482694.1]

This was applied to a database and it stopped the 'password' command from succeeding in SQLPLUS. Once the trigger was disabled, it worked fine.

ORA-00604: error occurred at recursive SQL level 1
ORA-06531: Reference to uninitialized collection
ORA-06512: at "SYS.NAME_SECURITY", line 165
ORA-06512: at line 2

Why is this behavior seen? By the way, he was able to change the password using TOAD. Only sqlplus is the issue.

View 2 Replies View Related

Data Guard :: Change Non-SYS Password On Oracle 11g Environment?

Jul 26, 2012

how to change non - SYS oracle users' password in data guard envirnment. We all know that for SYS password change in data guard. DBA has to change in primary database by either "alter user SYS identified by xxxx" or create password file with orapwd.

Then scp password file to standby database. However, if I want to change SYSTEM or DBSNMP passwords, I change on primary with " alter user ....." SQL, then new passwords will be login dictionary. But this new SYSTEM pqssword will be shipped with redo log to standby and SYSTEM password on standby will be updated? I need technical answer on this question

View 7 Replies View Related

Application Express :: Place Change Password Link Next To Page Logout?

Oct 17, 2012

I want to place change password link at the upper right of the page where logout link is..

i m using apex 4.1

View 2 Replies View Related

Reports & Discoverer :: Calling Report From Form Asking Enter Password

Nov 28, 2010

I am calling a report from Form 6i by using RUN_PRODUCT.After pressing the call button from Form 6i, report is showing box for enterning user id and password.

View 5 Replies View Related

Forms :: Cannot Commit Form When New Instance Form With Form Status Is NEW

Apr 17, 2012

I cann't commit form when new instance form with form status is "NEW".

And then i call:
Text_Item := WebUtil_File.File_Selection_Dialog('', '', 'Excel 2003|*.xls|Excel 2010|*.xlsx|All File|*.*', 'Select a file to Import', Open_File, True);
Form status change to "QUERY"

And then i click button "Import Data" from excel file to Data Block. Now form status change to "CHANGED". But i cannot call "Commit_Form" built-in to insert data to database oracle 10g.

View 9 Replies View Related

Application Express :: Tabular Form - Change Column Values Before MRU

Jun 4, 2013

I have a problem with Tabular form. Configuration: Oracle 10g, Application Express 4.1.0.00.32.

I have tabular form on simple table. I need to change some column values before MRU. For example: i have column named "UPDATE_DATE" where i need write SYSDATE every time this record was updated. I've created page process, associated with my tabular form.

Process point: On Submit - After Computations and Validations;
Sequence set to 1 (before "ApplyMRU" process - it has sequence 10);
When Button Pressed: Submit;
Execution Scope: For Created and Modified Rows;

Source:

declare
indx varchar2(255);
l_map wwv_flow_global.vc_map;
l_id number;
l_pk number;
begin
[code]........ 
   
But this doesn't work. MRU process writes old values, that was posted from browser. I tried change values by

apex_application.g_f04(:APEX$ROW_NUM) := sysdate;but this also not work.

How can i change values before MRU? Why wwv_flow_tabular_form.set_row_values doesn't change values?

View 5 Replies View Related

Application Express :: Change Form Text Field Label Using Javascript

Oct 22, 2013

I have a field that will be providing different info based on document type. I would like to change the field label from javascript in DA. 

View 3 Replies View Related

Forms :: Opening Form Has Attached Libraries Caused Form Close

Jul 19, 2010

If I open a form has attached libraries in form builder on windows7 it closed and give this message :

Problem signature:
Problem Event Name:APPCRASH
Application Name:frmbld.exe
Application Version:10.1.2.0
Application Timestamp:42d63632
Fault Module Name:KERNELBASE.dll

[code]......

View 14 Replies View Related

Forms :: Want To Call Web Form For Uploading Image From Custom Form

Apr 16, 2013

I want to call a Web form which should upload the image from my local machine.For that I have created a form which will take necessary data about employee now I want to Insert Image for that employee into table as I am new I struct on the Image uploading form. Latter I have seen the Enter & Maintain form which have Picture button.Pressing this button we get one new web form open & we can upload our image from there.

View 1 Replies View Related

Forms :: How To Reload Calling Form After Closing Called Form

Jul 15, 2007

I have FORM_A calling FORM_B: Call_form('FORM_B',...). On form_B I am updating a Record and when I close Form_B and the focus goes back to Form_A, I need to Automatically Reload Form_A to reflect the changes that were made on Form_B.

How can I reload the Calling Form (FORM_A) when I closed the called form (FORM_B)?

View 13 Replies View Related

Forms :: 2 Different Form To Pass Values From One Form To Another

Mar 11, 2010

is there any type of veriable used in declate statement whith could be used in 2 different form to pass values from one form to another.

View 1 Replies View Related

Forms :: Creating A Username And Password In Oracle Forms 6i

Sep 12, 2010

I created a form to create a username and password.i tried creating a user in forms 6i using the following code on the when button pressed trigger:

BEGIN
forms_ddl('create user'||:user_name||'identified by'||:pasword);
commit_form;
END;

i have granted the user to create user but it does not work at all. password and user_name are captured in the form.

View 7 Replies View Related

Forms :: Any Way To Load A Form Within A Form

May 21, 2010

I have a requirement, is there any way i can achieve the following User Interface using oracle forms

Left Pane: Navigation (Tree Menu)
Right Pane: Based on the node clicked in the Tree Menu, a specific form will be loaded on the right.

The tricky part, is there any way i could load a form within a form ? If i make use of OPEN_FORM, it will open a form in its own window.

View 2 Replies View Related

Forms :: How To Open Another Form Within A Form

Dec 20, 2012

I want to convert my forms6i application into forms9i therefore I initially converted my login and explorer form.

In my login form, I am using NEW_FORM to close my login form and wants to activate my explorer form but every time a pop-up raised and asked "DO YOU WANT TO CALL THE NEW FORM?", if I pressed YES then pointer moved to explorer form.

This form is working perfectly in 6i and didn't asked anything and moved to successfully to explorer form.

View 2 Replies View Related

Forms :: Pre-form And When-new-form-instance?

Mar 1, 2010

What is the difference and significance of

1) Pre-form and When-new-form-instance?
2) Post-text-item and When-validate-item?

View 5 Replies View Related

How To Know Password (Exact Password Not Hascode) Of All Users As A Sysdba

May 28, 2008

How to know the password(Exact password not hascode) of all users as a sysdba in Oracle 9i or 10g.How to convert hashcode password to Actual password.

View 1 Replies View Related

SQL & PL/SQL :: Create Procedure That Will Send In Customer ID / Password And New Password

May 14, 2011

I am trying to create a procedure that will send in the customer id, password and new password. The procedure will say if it has been updated or not. this is the code i have.

--Patty Carson
--Assignment 3 Question 3
--Description: Allows the user to change a password for a customer
CREATE or REPLACE procedure ChgPwd
(custid OUT number, password OUT VARCHAR2, newpassword IN VARCHAR2)
AS
[code]...

View 15 Replies View Related

Security :: Create Password File / Don't Know Password Of Sys User

Jun 5, 2012

I want to know what if any person don't know the password of SYS, can he create password file, becauase i dont know the password of sys users, generally login with '/ as sysdba',

View 4 Replies View Related

Forms :: Password Decryption With Oracle 9i

Jul 21, 2010

I am facing password decryption problem with my oracle forms 9i version. (forms 9i , d/b-oracle10g, application server 10g)..My current db is in oracle9i (windows server), it is migrated to oracle 10g in unix server. (dont have more details about server).

In my application "loginscreen.fmb" is fetching the p/w from security_table (here p/w stores in encrypted format) and decrypt at form level. If both are matching, then only it allows the user to proceed further.But when it is decrypting p/w from the forms(internally calling the decryption function from d/b), junk data is displaying (i put debug mesage and found this ).

when forms connected to the d/b if that is in unix server, decryption functionality will not work? I did same decryption using the same key from sql*plus, it is giving correct values. What is the diff between decryption from forms and sql*plus ( both case it is calling the same function that is stored in the d/b).

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved