0

I come from an Oracle background, and I'm used to the concept of OS users that can login to Oracle with DBA privileges in the machine the DB is installed on using their OS credentials as long as the OS user is part of a certain OS group (oinstall) using the below syntax:

sqlplus / as sysdba

In a machine (Oracle Linux 6.3) where Sybase ASE (15.7) is installed, is there any way I can login the same way as sa user?!

2

I'm assuming sqlplus is designed to allow password-less DB access under certain scenarios (eg, a custom perl script running under the same scenario doesn't, by default, have password-less access to the Oracle DB) ... ?


SAP(Sybase) ASE does not come with any applications which, by default, allow for password-less access to the dataserver.

Having said that ... it is possible to setup password-less access, eg:

  • design your own custom app that provides password-less access [will likely have to rely on a password file, or an approved method of external authentication]
  • configure your environment with one of the approved methods of external authentication [see ASE Security Admin, External Authentication for more details]
1

Note that the "approved method of external authentication" web page says:

To use these external authentication methods, you must obtain the ASE_SECDIR security and directory services license package.

So it costs extra money to do something that should be basic like this. Such is the way that Sybase (er, SAP) does things.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.