Skip to Content
0
Jul 13, 2008 at 06:41 AM

ddic and sap*

242 Views

hi all,

i have 2 questions to ask,

-


1) in the ides system , with client 000 the uesrs DDIC and SAP* passwords were changed and i forgot the password.*

also i don't know the passwords of any other users that exist in the client 000.

i tried to delete the user sap* from the sql command level by using the option ::

SQL> DELETE FROM EC6.USR02 WHERE BNAME='SAP*' AND MANDT='000';

SQL> ERROR at Line 1:

ORA--00942: Table or View doesnot exist.

but when i see the same table USR02 using tcode se11 it exists.

what could be the problem and how to unlock the sap* and ddic users.

-


2) my question is regarding ddic.

i forgot the password of ddic and suppose i unlocked it using the above statement.

but for ddic user there is no auto-generated password which exists for sap* (pass). (( i hope i am correct about this statement))

then how can i login into ddic user even when the user is unlocked and i don't have the standard or any other password.

-


regards,

bhupesh