cancel
Showing results for 
Search instead for 
Did you mean: 

Connect as SAPSR3 on Sybase ASE 15.7 ?

Farid
Active Participant
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Johan_sapbasis
Active Contributor
0 Kudos

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

Answers (3)

Answers (3)

Former Member
0 Kudos

Hello Raoul,

where you able to resolve the issue.

Let us know if you resolved it with solution.

Regards

Anand

tilman_model-bosch
Contributor
0 Kudos

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
0 Kudos

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