Search results for query: *

Hi Turkbear, Can we write directly 'PK' as you have written as given Delete from existing records_table where PK not in (select PK from incomingdata_table) OR, we have to write primary_key not in OR, we have to write primary key. would apprciate if you could let me know. Thanks and...

Hi Dagon, Thanks a million for your prompt reply !! But, to put it simply, how do I check the condition for UPDATE ? Condition: If the PK for the incoming record exist in the database, the corresponding master table (database) is updated Thanks and regards, Friend33

I have a Composite Primary Key (PK) based on 4 columns. How to do DML (Insert, Update, Delete) based on the uniqueness of PK ? here it goes in a bit detail 1) If the PK for the incoming record does not exist in the master table (database), create a new record. Q: Can you please let me know...

Hi Friends, Have a small query and would love if somebody could tell me the answer. :0) Have in the database:: 'Create profile prof limit password_reuse_time 365;' Alter user <username> profile prof. My doubt is - whether this parameter is visible in the front-end (Developer 2000) and...

Hi Friends, Would appreciate if you could spare a moment and have a look at the procedure. The procedure is not compiling successfully and it throws up an error asto the 'Begin' and 'End' keywords. Could you please have a look and let me know the problem ? Thank You, Friend33 Create or...

Hi Friends !! Can someone please provide the functionality ? - Archive Manager Password Expiry History Keeping Thank You, Friend33

Hi Tharg Thanks for letting me know the answers to my silly questions. Have 3 short questions. Hope you would answer them:: 1. How can we have a password generated by the system ? (Not manually) 2. Can you provide some inputs regarding 'Password History' built-in functionality ? 3...

Hi Tharg, Thank you for the help you have rendered to me so far. Had 2 small issues (silly ones !!) so i thought i could ask you. 1. In 'alter user scott password expire' which we write after the user has been e-mailed a username/password combo. But, where specifically do i write this...

Hi Tharg, You are a boon in disguise for me. I really appreciate your help. Thanks once again for your valuable tips !! Have a nice day !! :) Ravi

Hi Tharg, Any ideads on the newest thread 'New Password - After Forgot Password' which you were mentioning before ? Thank You, Ravi

Hi Friends !! After the 'Forgot Password' functionality has been introduced at the User Admin Login page, it's time for the user to change the password, so that the user has to change the password at the next logon. Any inputs asto how to implement this ? Many Thanks, Friend33

Hi Thargtheslayer, One quick question ! I know it is silly but is the password created by the user in this case ? Please explain. Thank You, Friend

Thank You, Thargtheslayer

Hi Friends, Need to provide 'Forgot Password ?' functionality at the login page. If user selects this option then a password reset will be done by the system and a new password will be mailed to the e-mail address held against the users account in a Oracle table. My query is how to generate...

Hi Tharg, Thanks for your prompt reply. When you mention 'Oracle automagically obfuscates password info', can you tell me asto how Oracle recognizes that the text is a password column ? Also, can you tell me the steps to store the password in a table and keep it encrypted ? Thank You...

Hi Dima, Is the password encrypted while it is stored in a table ? Pl. confirm. Thanks, Friend

Hi Friends, Have 2 queries and hence was wondering if you could answer them. 1 A form must be designed to prevent users from reusing passwords that have been used in the last 12 months. 2 Also, since the password is stored in a Oracle table as plain text, how can we encrypt it ...