Ah, thanks. Didn't try anything with that Friday.
Jared
On Sunday 09 March 2003 22:58, Alex Feinstein wrote:
Jared,
Look at Note 60634.1 on MetaLink.
OSAUTH_PREFIX_DOMAIN = TRUE is default for 8.1 and 9.
Alex.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL
Ran into an interesting problem with this on Friday.
We've put together a new SAP server that is not yet attached
to a network, and so are using local account names rather than
the normal domain accounts until we're ready to put it on the
network. ( We're replacing another server, and this one
Jared,
Look at Note 60634.1 on MetaLink.
OSAUTH_PREFIX_DOMAIN = TRUE is default for 8.1 and 9.
Alex.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Sunday, March 09, 2003 10:08 PM
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Hello,
env: Oracle 9.2.0.2 on Solaris 9.
Does anyone know of a way to use the / as sysdba logon remotely?
(to a separate Oracle instance on a separate machine)
Other remote user logons work OK.
I have tried several variations from sqlplus, such as
[EMAIL PROTECTED]connect /@DWQ as sysdba
have you got the remote login password file ?
if you set it I think it should work .
take a look at Note:1016540.6
-Original Message-
[mailto:[EMAIL PROTECTED]
Sent: Thursday, March 06, 2003 7:09 PM
To: Multiple recipients of list ORACLE-L
Hello,
env: Oracle 9.2.0.2 on Solaris 9.
Title: RE: remote / as sysdba
As far as I know, it works like this:
You will need to set init parameter REMOTE_LOGIN_PASSWORD_FILE to EXCLUSIVE.
You then can sign on as SYS remotely, or as another user remotely if the other user has SYSDBA. See the users that have SYSDBA or SYSOPER in v
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:remote / as sysdba
Hello,
env: Oracle 9.2.0.2 on Solaris 9.
Does anyone know of a way to use the / as sysdba logon remotely?
(to a separate Oracle instance on a separate machine)
Other remote user logons
to
connect to? I tried setting TWO_TASK to the tns_alias for the database, but
that didn't help. It seems to me that when you enable remote SYSDBA logins
Oracle will insist on verifying a password for the SYSDBA user in the
password file.
Or is there some clever trick I don't know about?
-Original
Title: RE: remote / as sysdba
If you want to do
connect sys/[EMAIL PROTECTED] as sysdba
then the database corresponding to TNS alias DWQ has to have remote_login_passwordfile EXCLUSIVE, and it needs to have a password file.
It is not clear to me from your e-mail if remote database DWQ has
Kilchoer [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
03/06/2003 12:14 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:RE: remote / as sysdba
As far as I know, it works like this:
You will need to set
of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:RE: remote / as sysdba
*** Comments by BECKER, BILL Thu Mar 06, 2003 -- 03:30:49 PM
I have tried this, but it still does not work.
[EMAIL PROTECTED]select value from v$parameter
2 where name
Title: RE: remote / as sysdba
I forgot that you could do that. I never liked remote os authentication (is it still possible to easily fool a client into thinking you're someone else?), and I would like it even less if it allowed you to sign on as SYSDBA without a password. The best security
]
cc:
Subject:RE: remote / as sysdba
I forgot that you could do that. I never liked remote os authentication
(is it still possible to easily fool a client into thinking you're someone
else?), and I would like it even less if it allowed you to sign on as
SYSDBA without a password
Title: RE: remote / as sysdba
Thank you for the information. I thought the security issues were more fundamental. For example if my database has remote os authentication (with prefix OPS$), and I know that there is a user called OPS$JSTILL, then I can change the Windows Registry on my client
14 matches
Mail list logo
