Difference Between #username And ?username In SPARE1 Column?

Oct 31, 2010

whats the different between a #username and ?username in a SPARE1 column?

View 5 Replies


ADVERTISEMENT

SQL & PL/SQL :: Get User_id When Given Username

Jul 16, 2010

I would like to retrieve user_id when I give username. Could I know which tables I need to be using for that.Example

SQL>@get_User_id Greg
b7dhgs
igh45g

where 'Greg' is a part of the name for 2 users.

View 11 Replies View Related

Oracle 9i Default Username And Password

Sep 14, 2003

I Just got Oracle 9i installed. But can not login . What are the Default username and password for "Oracle9i Discoverer Administrator" and other Developers Suite apps?

Also What URL should i type to access the "iSQL *PLUS" through my browser, so that i can execute my SQL statements.

View 3 Replies View Related

Forms :: Hide Username And Password?

Mar 21, 2011

I already did the hide of username and password, now i need to recieve in cgicmd.dat a parameter because i already have the way of reports i want only to recieve the name of them, so i put like this:

sct: userid="user/pass@database" destype=cache desformat=pdf report=c:\%1

So when i run this show me the message:

File 'c: este.rdf=%' not found.

It's showing a '=' sign

View 1 Replies View Related

Forms :: Database Username Display

Jun 18, 2012

I want to display the current database username in a text field after logging in at run time,i.e after logging in the username should should display in a text field.e,g. if i login as scott then 'scott' should display in the text box.

View 3 Replies View Related

Username While Connecting To Sqlplus /as Sysdba

Mar 13, 2013

I am in a bit confusion about the user when we are logging in to sqlplus /as sysdba. what the user is when we are into sqlplus with sqlplus /as sysdba.

View 3 Replies View Related

Server Utilities :: Username And Password In Exp / Imp?

Apr 26, 2011

While doing export/import we specify the username and password. Preferably which user do we need to specify? Sys or system or our own user?

View 9 Replies View Related

Executing Function To Return Username In Oracle

Feb 6, 2006

I have created a Package Body and Package Spec for a function to select a username and a password from a table and return the username.

The code i have created is this:-

CREATE OR REPLACE PACKAGE BODY USER_LOGIN
AS
FUNCTION user_select (USERNAME_IN VARCHAR2,
PASSWORD_IN VARCHAR2)
RETURN VARCHAR2 IS
USERNAME_OUT VARCHAR2(12);
BEGIN
[code]........

The package body and spec compiles successfully but i am having trouble when i execute this function. I am trying to do this :-

VARIABLE RETVAL VARCHAR2(12)

EXEC User_login.user_select('HELLO','HELLO',:RETVAL );

but i am getting the following error

ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'USER_SELECT'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

View 5 Replies View Related

Loop - Two Variables (username / Password) Not Clearing Out?

Apr 15, 2008

The idea of the program below is to create a sql "module" (just a .sql file) that will loop and ask for a user id until the user enters the correct one. Here is the code I have thusfar:

set serveroutput on;
accept username prompt 'Enter user name here: ';
accept password prompt 'Enter password here: ';

declare
usernameCONFIRM VARCHAR(30);
passwordCONFIRM VARCHAR(30);
begin
select USERID into usernameCONFIRM from GAMEUSER where USERID = '&username';

[code]...

The main problem I'm seeing is that the two variables I ask for (username and password) aren't clearing out.

View 12 Replies View Related

Oracle Sqlplus Unique UserID / Username?

Oct 5, 2007

I each user in my table to have a unique username and user_id. So the table cant contain 2 users with the same user id and it cant contain 2 users with the same username.

oracle doesn't support more than one primary key in a table

so what could I use a secondary key?creating alternate keys in sql plus?

View 1 Replies View Related

Client Tools :: How To Find Username In Sqlplus

Aug 16, 2011

How to find user name in sqlplus?

View 5 Replies View Related

Forms :: Fetching Data - Retrieve Username

Sep 7, 2010

I have a detailed block with a user ID column. The user name is not available in the block. Therefore, I have created a non-database column to retrieve the user name into it.

Here is the code I've used.

PROCEDURE get_details IS

iLoop number := 1;

CURSOR c is

SELECT FULL_NAME
FROM GRP_EMPLOYEE
WHERE EMPLOYEE_NUMBER = :USER_ID;

[Code]...

However, it retrieves the first record only.

The results are displayed like this.

Loop: Result:

1 Full_Name
2 Empty
3 Empty
4 Empty

View 2 Replies View Related

Application Express :: XDB Requires Username And Password

Jun 1, 2013

11.2.0.1.0 g database.

I am trying for testing on test server where I am getting error while trying to connect

[URL].....

I am able to connect

[URL]........

and

[URL]......

The database version is 11g.

Actually my requirement is As I know we cannot use isqlplus in 11g we can use apex instead of isqlplus so any way or navigation how to use apex for isqlplus.

View 1 Replies View Related

Reports & Discoverer :: To Hide The Username And Password

Dec 20, 2010

I migrated the report from Developer 2000. This report has the drill down report with the following command.

procedure U_1ButtonAction is
begin
srw.run_report('rep022.rep paramform=no
p11="'||:cr_call_ref_no||'"');
end;

After Migration into Oracle Application Server 10g release 2 , I changed the code as following:

function U_1FormatTrigger return boolean is
begin

SRW.SET_HYPERLINK(' http://cpstest.exch1.mas.unb.com:7778/reports/rwservlet?report=E:CallSystem
ep022.rdf&USERID=dss/dss@dsdb&destype=cache& ;desformat=pdf&p11="'||:cr_call_ref_no||'"');
return (TRUE);
end;
-----------
Problem

When I run the report, it shows the toolbar on the link [with the user id & password] of the drilldown report.

I wish to hide the username & password or I wish to enter my message "Click the link to open the Report".

View 5 Replies View Related

XE :: Error ORA-01017 Invalid Username / Password

Feb 15, 2013

I just finish to install Oracle XE on Fedora 18 so when I try to Start SQL, I get this error.

[root@fedora ~]# sqlplus system

SQL*Plus: Release 11.2.0.2.0 Production on Fri Feb 15 02:18:14 2013
Copyright (c) 1982, 2011, Oracle. All rights reserved.

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

View 2 Replies View Related

Detecting Full Domain Name / Username For Connected OS User

Oct 20, 2010

If I'm looking on v$session - values in osuser column for some machines displayed with DOMAINNAME, and for other - without. Even same user (MYDOMAIN\ADMINISTRATOR) from 2 different machines displayed in 2 different ways on the same db:

MYDOMAIN\Administrator from machine A, and administrator from machine B.

Both machines are belongs to same windows domain. DB (oracle 10g) have no "DOMAIN" defined.

What make the difference? And can I somehow to affect this behaviour? I mean, can I define that all users will be displayed as DOMAINNAME\USERNAME or MACHINENAME\USERNAME(in case of no domain exists)?

View 8 Replies View Related

SQL & PL/SQL :: How To Give Username And Password When Calling HTTP Page

Apr 16, 2013

I have this code when i run this I get credentials error. How to give credentials .The authentication is set to windows in the https page. Means pop up will appear to get the credentials

declare
req UTL_HTTP.REQ;
resp UTL_HTTP.RESP;
value varchar2(1024);
p_url varchar2(4000);
OPT varchar2(1000);
BEGIN
dbms_output.put_line('');

[code]....

View 1 Replies View Related

SQL & PL/SQL :: Oracle - Create Procedure To Check Username And Password?

Aug 23, 2011

how can i create procedure to check username and password.

View 10 Replies View Related

Server Administration :: Can't Login By Typing Username And Password

Jul 15, 2010

I am using oracle 9i version. My problem is oracle window opens.But i can not login by typing the user name and password. while login an error is displayed as follows.

ORA-01033: ORACLE initialization or shutdown in progress.

View 8 Replies View Related

Forms :: Invalid Username / Password - Login Denied

Aug 9, 2011

I have installed oracle 10g database in my pc and it works fine. I can connect with sys or system user.

I have also installed oracle forms 10g in the same pc. But when I try to connect then it shows the message:

ORA-01017 invalid username/password; login denied

So I can not connect. I have tried to connect with sys or system user.

View 6 Replies View Related

Getting ORA-01017 Error Invalid Username / Pwd Logon Denied

Oct 19, 2010

i am getting ORA-01017 error frequently .

we have an application that is running from remote host to connect database using JDBC driver 10.2.0.2

but i am getting ORA-01017 error intermittently. we fetching stored username/pwd after every 5 min but for certain interval it's giving error and we get connection sucessful after some time with same username pwd.

the application monitor more number of databases but facing problem with only 1 instance.

View 1 Replies View Related

ORA-01017 - Invalid Username / Password - Logon Denied

Jun 26, 2012

Case 1,

-I have a Oracle Client 11.2.0.1 (*Administrator*) installed on a client machine on Redhat 6.
-I have a database 11.2.0.1 testdb installed on another machine.

I configured tnsnames.ora for the client machine to connect my database testdb.If I use sqlplus to connect to the testdb from client machine, it's successful.However, If I use one of the jdbc connection string from the client machine, it reports "ORA-01017: invalid username/password; logon denied"

Case 2,

-I have a Oracle Client 11.2.0.1 (*Runtime*) installed on a client machine on Redhat 6.
-I have a database 11.2.0.1 testdb installed on another machine.

I configured tnsnames.ora for the client machine to connect my database testdb.

-If I use sqlplus to connect to the testdb from client machine, it's successful.
-If I use one of the jdbc connection string from the client machine, it 's successful too.

For case 1 and case 2, the only difference is the Oracle client (one is Runtime, the other is administrator)The database I have is set to

SQL> show parameters case

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
sec_case_sensitive_logon boolean FALSE

why the administrator client report ORA-01017?

View 15 Replies View Related

Security :: DBA_AUDIT_SESSION Failed Login For Username That Does Not Exist

Aug 23, 2012

When reviewing failed login attempts with this query:

SELECT username, os_username, userhost, terminal, to_char(timestamp,'dd-mon-rrrr hh:mi:ss')
FROM sys.dba_audit_session
WHERE returncode != 0
and trunc(timestamp) >= trunc(sysdate-1)
ORDER BY 5

I find some records for a username that does not exist. In any of my databases. I presume that if an attempt to a nonexistent user was made, it would be rejected before it gets to the db. But then again, a bad password would also be rejected.

View 1 Replies View Related

Reports & Discoverer :: How To Hide Username And Password In Web Show Document

Jul 1, 2013

I want to hide the URL or Username and password in web.show_document. While accessing report through form any end user can see the url. I need to hide the credentials.

View 6 Replies View Related

Security :: ORA-01017 / Invalid Username / Password - Logon Denied

Jul 2, 2011

I am not able to login in the database with sys user. when i am trying with sqlplus "/as sysdba" it is showing

ERROR: ORA-01031: insufficient privileges.

& when i am trying with sqlplus sys as sysdba it is showing

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

I login with system user and changed the password of sys nd then tried login with sys but same result.

remote_login_passwordfile is set to NONE nd i am login through that user only by which i was always able to login.

View 23 Replies View Related

Windows :: Detecting Full DOMAINNAME USERNAME For Connected User?

Oct 20, 2010

If I'm looking on v$session - values in osuser column for some machines displayed with DOMAINNAME, and for other - without.Even same user (MYDOMAINADMINISTRATOR) from 2 different machines displayed in 2 different ways:

MYDOMAINAdministrator from machine A, and administrator from machine B.Both machines are belongs to same windows domain.

What make the difference?And can I somehow to affect this behaviour? I mean, can I define that all users will be displayed as DOMAINNAMEUSERNAME or MACHINENAMEUSERNAME(in case of no domain exists)?

View 6 Replies View Related

SQL & PL/SQL :: Creating Store Procedure That Will Accept A Username From A Flat File?

Apr 8, 2012

I'm trying to create a store procedure that will accept a username from a flat file but i don't know how to do read file into store procedure.

Below is a sample store procedure by itself i created to add user which created okay but when i execute I got the error displayed below.

create or replace procedure addUsers(userNam in varchar2)
is
begin
EXECUTE IMMEDIATE 'CREATE USER'||userNam||'IDENTIFIED BY "pass1234" DEFAULT TABLESPACE USERS'||'QUOTA "1M" ON USERS'||
'PASSWORD EXPIRE';
end addUsers;
/

[code].....

View 21 Replies View Related

Security :: ORA-01017 - Invalid Username / Password - Logon Denied?

Sep 24, 2013

I have a log-in problem. I created the new database and when I try to log-in with system user, its giving ORA-01017: invalid username/password; log-in denied, and when I try to log-in with "/ as sysdba" its successfully logged in.

When I try to change SYSTEM user password, I successful change and connecting and after few seconds when I try to connect its again giving same error "ORA-01017: invalid username/password; log-in denied

And I disable the case sensitive password also:

sec_case_sensitive_logon boolean FALSE

OS: windows
Oracle Versions: 11.2.0.1.0

View 6 Replies View Related

Data Guard :: ORA-17627 / ORA-01017 Invalid Username / Password

Aug 21, 2013

I have a strange behavior with a Data Guard environment on Linux and Oracle 11.2.0.2. Since a couple of days, I have the following error in the alertlog of the standby database: 

Errors in file /u00/app/oracle/diag/rdbms/SID_site2/SID/trace/SID_pr0f_22728.trc:ORA-17627: ORA-01017:
invalid username/password; logon deniedORA-17629: Cannot connect to the remote database server First I restarted the Apply on the standby without any changes.

So I tried to connect to the primary database from the standby server with Oracle .Net with success. In the other way, it's also working.I also tried to copy the password file from the primary server to the standby server and I restarted both the transport and the apply.The error is still happening on the standby but the most surprising is that the Data Guard is still fully synchronized. Why I get that error and what is the function of the process pr0f?

View 13 Replies View Related

Application Express :: Cannot Use Username Into Conditional Part Of Action Item

Sep 14, 2012

For our customer we have build a custom login page. The form we currently made has de following items:

- Username
- Password
- Select list for selecting the task type

When the customer enters his username, automatically the select list of the task type will be refreshed to get only the task type where the customer has the rights to do it. This part works...It can occur that a customer has only one task type (which is default) then we want to hide the select list. This part doesn't work

We used APEX version 4.1.1.What we did is:

- One action item to refresh the selection list (works)
- One action item to hide the selection list by starting the application (works)
- One action item to show the selection list only when the selection list has more than one result. For this part we used the conditional part of the action item (Function returning a boolean).

In the query (inside the function) we want to use the entered username, looking into the application in the session state I saw the correct username, but for some reason the function cannot use this entered username, it becomes empty. When I use a hardcoded username the code works.

Why I cannot use a username into the conditional part of the Action Item.

View 3 Replies View Related







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