Connect as SAPSR3 on Sybase ASE 15.7 ?

[Farid]

Hello,

After 15 years working on Oracle, I had to switch this week to Sybase ASE 15.7 on Linux RedHAt.

I understand how to connect woth the users sa,sapsa,sapsso.

But I need to check that SAPSR3 password is correct, I did some digging could not find how to do that

Is there an equivalent procedure on Sybase allowing us to perform a Connect as SAPSR3 ?

Thanks and Regards

[Johan_sapbasis · Accepted solution]

Hi Rauoul,

Refer to sapnotes:

1796540 - SYB: Password changes with sybctrl

1706410 - SYB: Security - Changing passwords for database users

It lists the steps in detail start with 1796540.

Kind Regards,

Johan

[Former Member]

Hello Raoul,

where you able to resolve the issue.

Let us know if you resolved it with solution.

Regards

Anand

[tilman_model-bosch]

Dear Mr Shiro

the 'setuser' command in ASE may also be something that can be useful:

Connect to ASE as user 'sapsa' with isql

swithc to the SAP database and then execute the setuser command:

Example - after you connected to ASE with isql as 'sapsa' :

1>use <DBSID> --switch to SAP database
2>go

1>setuser 'SAPSR3'
2>go

Now your context is that of the 'SAPSR3' user in the <DBSID> database.

The SAP DB course ADM540 might useful for you , if you are new to ASE .

With kind regards
Tilman Model-Bosch

[Former Member]

Hello Raoul,

Please check the following SAP note:-

1706410 - SYB: Security - Changing passwords for database users

1872806 - How to set a new password for SA account in Sybase ASE server

If you are aware of SAPSR3 password try to change it with same password.

It will give message saying ...there is no change from previous password.

Regards

Anand