Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

How to reset DDIC password in client 000 from OS leves ?

Former Member

‎04-16-2008 10:08 AM

0 Kudos

Dear All,

Please some one can help me to reset DDIC pass under OS or Database, since our security team forget the DDIC pass in client 000, and nobody have acces to client 000.

Since we we are running in Oracle 10 G there's any command from sql oracle to unluck and try to reset this password from Os level,

Thanks and Best Regards,

Chrisna

1 REPLY 1

Bernhard_SAP
Employee
Employee

‎04-16-2008 10:35 AM

0 Kudos

Hi Chrisna,

that is not applicable for user DDIC, but you can do it for user SAP*.

If no entry for SAP* exists, the password for SAP* is PASS.

If you do not have access to the system, you can also check the

existance of SAP* with DB-tools. The entry to look for is in table

USR02.

If no user can log on to the system/client, you can then delete the

entry in USR02 with DB-tools. After that you have to restart the system,

as the table is buffered from Release 6.x on.

Please do not forget to check the systemparameter

login/no_automatic_user_sapstar (it has to be set to 0 to enable

SAP* to log on w/o entry in USR02).

For further documentation please have a look at the notes

#68048 - Deactivating the automatic user SAP*

#8852 - Logon with SAP* password 06071992 not possible

#2383 - Documentation: description of "super user" SAP*

b.rgds, Bernhard