PL/SQL :: User Session Has Expired And Enable User Without Changing The Password

Aug 13, 2012

User session has expired. I have to enable user without changing the password of the user.

View 1 Replies


Security :: User Password Expired?

Nov 11, 2011

i am using a oracle server. And all my users password has been expired, is there any way to recover those users without failing my data.

View 19 Replies View Related

Security :: User Locked / Track User Who Hit Wrong Password

Dec 21, 2010

We have the database user called c88888 and is locked yesterday. I came to this with the following query.

select * from dba_users where username like 'C88888';

Due to invalid password the user was locked. Can we track who hit the database with the wrong password?

View 5 Replies View Related

How User Xyz Account Expired Within A Month

Aug 22, 2013

Created user xyz on July 20,2013 with defualt profile (oracle version 11.2.0) and PASSWORD_LIFE_TIME is 180 for default profile. Immediate my friend have assigned new profile APSC to user xyz where profile APSC has PASSWORD_LIFE_TIME = UNLIMITED.

we surprised, user account has expired within a month. How user xyz account can expired within a month????

Note: User account status was open when account created and assigned to profile APSC.

View 4 Replies View Related

Application Express :: Kill Current Session When Another Session With Same User Starts

Nov 19, 2012

I have an urgent requirement to kill an existing session if a new session starts for the same user. I have been reading lot of blogs and posts on the above topic, but could clearly tell me how to do it.

I thought of putting a process in 101 page when login button is pressed to catch this and kill the old session.

View 7 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 :: Enable User To Select And Save Any Document Into Database?

Dec 6, 2012

how can i enable user to select and save any document into oracle database and later on choose to retrieve and display should be like windows file open save.

View 2 Replies View Related

SQL & PL/SQL :: How To Get User Password

Mar 20, 2012

Find out the password of his / her any user in oracle , in readable form? if yes then how?

View 15 Replies View Related

Forms :: Alerting User When Changing Field Without Content?

Jan 5, 2012

I had created a form, in that i having two fields for username and password.

The problem is i want to make the fields as fill must.

if the user leaving the username field without entering anything trigger must raised. Otherwise if we are entering the data it should allow him to go for the next block without any raising of triggers.

View 8 Replies View Related

Session Details For A User

Nov 22, 2010

I have a user in my oracle database, I would like to know details such as, how many times and by using which tools same user has got logged for past one week.

How do I do that. I have sql which shows the current session either he is logged in, if so then which application or not logged in. But I required the information for past one week How do I get those details.

View 1 Replies View Related

SQL & PL/SQL :: User Session Details

Sep 14, 2010

How can I find out a user session/connection details like ( his last connection time, his activity etc)

Here is the issue, a old dba_user_id who physically no longer exists is not removed from the database. At some time, a session is opened under his user_id and some activity runs and closes the session. So, checked scheduled jobs under him and disabled them. But not sure whether the scheduled jobs are creating a session under his user_id or some thing else.

I checked in v$session, but since I am not sure at what time his session opens, so I am not able to get his session details.

View 5 Replies View Related

How To Find CPU Usage By Each User Session

Sep 7, 2011

I can get "CPU used by this session' value from v$sesstat. That is the value in centiseconds used by each session. How to convert the value into a percentage of total CPU resource ?

Or there are some other ways to gain the value. i.e. Percentage of Total CPU usage for each Oracle session.

View 5 Replies View Related

How To Obtain User Session Info

Jan 26, 2007

How do I get my list of user session info? I thought there was a user_session_parameter view or something? Basically, I did an ALTER SESSION ... and want to verify it was set correctly.

View 8 Replies View Related

Forms :: Hide User Name And Password?

May 4, 2010

when i want to call report from form how i can hide user name and password from the link in 10g ??

View 1 Replies View Related

Server Administration :: PGA Memory For Every User Or Every Session

Mar 18, 2013

I need to ask about PGA memory. Is this memory for every user or every session

i.e. PGA 200M

I have 2 users with 300 connection with one of them. Is 200M for 300 connection or for every connect.

View 2 Replies View Related

Security :: How To Configure End User Open Only One Session

Jun 10, 2011

I want to configure this

my end user open only one session

means one session per one user only

View 8 Replies View Related

Restrict Concurrent User And / Or Session From A Client?

Nov 5, 2012

We have an application with database Oracle 10g.

I want to add a new validation to restrict concurrent user and/or session from a client. (we have almost 60 client firms using the software to enter daily trasnactions). All users from all clients are connecting to the database using a common functional ID.

What I did was:
1) Add a column 'user_logged_in' in the master table for client and update it as Y when user from that client logged on to the system,
2) Insert the application logon details (we can figure out the client details from this) into a global temp table,
3) Create a logoff trigger to update the 'user_logged_in'flag in client master table by using values from global temp table when session logged off and
4) Restrict the users from same client if the flag is 'Y'

But the problem in this case is logoff trigger will not be executed in case if the session got killed or terminated abnormally.

View 3 Replies View Related

Security :: Create User With Non Expiring Password

Jul 7, 2011

I want to create oracle user with non expiring password or i want to create one oracle user and set the password as non expiring.

View 9 Replies View Related

Security :: How To Generate User And Password Manually

Aug 27, 2012

i forget my system password and i can't login to my database,and its not letting me in as sys/manager as to generate new user and password....

View 13 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:

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.

(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

Express Edition (XE) :: What Is Default User Name And Password

Nov 29, 2012

I am a new to Oracle, Installed Oracle 11g express edition. Also I had installed Oralce SQL Developer tool but i don't know the user name and password to connect.

what is my default instance? what is my default user name and password? How to connect ?

View 2 Replies View Related

User Unable To Login Even After Password Reset

Nov 27, 2012 on Linux

I reset a user password and the user is unable to login as you can see below

[oracle@testdb 10.2.0]$ sqlplus sys/manager as sysdba

SQL*Plus: Release - Production on Tue Nov 27 16:20:21 2012

Copyright (c) 1982, 2006, Oracle. All Rights Reserved.

Connected to:

Oracle Database 10g Enterprise Edition Release - Production With the Partitioning, OLAP and Data Mining options

SQL> alter user sysman identified by oracle;

User altered.

SQL> Disconnected from Oracle Database 10g Enterprise Edition Release - Production With the Partitioning, OLAP and Data Mining options

[oracle@testdb 10.2.0]$ sqlplus sysman/oracle

SQL*Plus: Release - Production on Tue Nov 27 16:20:32 2012

Copyright (c) 1982, 2006, Oracle. All Rights Reserved.

ERROR: ORA-01017: invalid username/password; logon denied

User unable to login even after password reset

View 4 Replies View Related

Server Administration :: Monitoring User Session And Killing It?

Jun 8, 2010

I am using TOAD to monitor user sessions. I have a user who uses nearly 80% of Overall resources in the mornings. He calls me daily and say that his work is done. But even then the TOAD shows that he is using same resources for some time.

My question is can i kill the session once he confirms his work is done OR do i need to wait till the redologs are cleared.

View 9 Replies View Related

SQL & PL/SQL :: ORA-01001 - User Refresh SSRS Session And Again Run Query

Jan 11, 2012

We have a package procedure called from SSRS , which returns a REFCURSOR to the SSRS.Sometimes it throws the error. The user Refresh the SSRS session and again run the query , the error does not happen

Following is the error number

ORA-01001: invalid cursor

We have not used any static cursor , so this is not happening because we have opened a cursor and not closed it.The Cursor used is REF CURSOR and the output parameter is declared as

p_ref_cursor OUT SYS_REFCURSOR

The Procedure returns the Select query in the REF CURSOR.

View 7 Replies View Related

How To Find Length Of User Account Password In A Database

Jun 13, 2013

how to find length of the user account password in a database?

View 1 Replies View Related

Security :: User Unable To Login After Password Reset

Dec 14, 2011

We have a production database on version. The application user was prompted to change the password after his password expired.

------------------------------ --------------------------------------------------------------------------- ---------- ----------
M500796 13-DEC-11 PM 100 28001

After changing the password he is not able to logon. The aud$ table does not show any occurrence of 1017, therefore it is not a question of Invalid password.


------------------------------------ ----------- ------------------------------
sec_case_sensitive_logon boolean FALSE

View 2 Replies View Related

Server Administration :: How To See Schema User Password In Text

Oct 1, 2012

I need to see all schema users password in a text.I am database admin,but it difficult to remember the password of all users created in single database So we also dont want to change password of all time,table to view password in text. Also we all know we can see using dba_users, but it was showing in hash value i need it in a text

View 3 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:
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

Forms :: Captcha At Time Of Password Recovery To User

Jan 14, 2012

i would like provide a captcha at the time of password recovey to the user. is it possible to place a captcha in forms 6i. if possible how to provide it. i want the piece of code.

View 5 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

Copyrights 2005-15, All rights reserved