Rather, why do you want to connect as SYS ?
If you've created some custom tables in the SYS schema in an earlier
version,
create another user, connect as SYS in sqlplus, GRANT privileges to that
user
and connect as that new user in Forms. -- and think about migrating the
tables
out of the SYS schema.
If you are querying standard tables, OEM provides good views for most of
what
you need and the group here can provide better SQL scripts
anyway.
Hemant
At 07:29 AM 21-08-03 -0800, you wrote:
Try if it
works if you put sys/sys as sysdba to forms username prompt? (without
quotes)
But why do you want to connect as sysdba
anyway?
Tanel.
- ----- Original Message -----
- From: Robo
- To: Multiple recipients of
list ORACLE-L
- Sent: Thursday, August 21, 2003 11:54 AM
- Subject: Forms - as sysdba
- Hi all,
- I have a 9.2.0.3 DB and I need
to connect
to Forms 6i as user sys. There are 3 boxes for username, password and
database.
- I tried a lot of combinations, eg:
- Username:
sys as sysdba
- Password:
sys
- Database:
db
- sys/sys@db as sysdba
- sys/sys@db
/as sysdba
- sys/sys@db
'as sysdba'
- sys/sys@db
'/as sysdba'
- But I always get an
error message - either invalid username/password or TNS error (can't recognize the connect string).
- I have also tried it from command line but didn't succeed.
- Does anyone know if/how is it possible?
- Thanks a lot
- Robert Pipich
Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
My personal web site is :
http://hkchital.tripod.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Hemant K Chitale
INET: hkchital@singnet.com.sg
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Thu Aug 21 2003 - 10:54:27 CDT