How to reset SAP* and DDIC user passwords

Giovanni Davila

Published: 15 Sep 2003

How do we reset password for SAP* and DDIC user in SAP R/3 4.0B?

Step 2 of 2:

You forgot to provide an Email Address.

This email address doesn’t appear to be valid.

This email address is already registered. Please login.

You have exceeded the maximum character limit.

Please provide a Corporate E-mail Address.
- I agree to TechTarget’s Terms of Use, Privacy Policy, and the transfer of my information to the United States for processing to provide me with relevant information as described in our Privacy Policy.
Please check the box if you want to proceed.
- I agree to my information being processed by TechTarget and its Partners to contact me via phone, email, or other means regarding information relevant to my professional interests. I may unsubscribe at any time.
Please check the box if you want to proceed.

If you cannot log in as SAP*, you can carefully delete it at the database level.
Issue a delete statement against table USR02, which is the one that keeps the passwords.
Example: delete USR02 where BNAME = 'SAP*' and MANDT='100'
Make sure you delete it only in the desired client.
After this, you will be able to log on as SAP* again with password PASS.
Then, you can change the DDIC password and go from there.

Dig Deeper on SAP Basis

Related Q&A from Giovanni Davila

SAP Basis best practices for transferring a client from one server to another

Learn how to transfer a client from one server to another in this administration tip from Basis guru Giovanni Davila. Continue Reading

SAP transport management fundamentals

Learn fundamentals of transport management and STMS from Basis guru Giovanni Davila in this expert tip. Continue Reading

Copy from the production system to the development system

Giovanni Davila, Basis expert, provides advice on how to copy all SAP users from one system to another in this tip. Continue Reading

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

Meet all of our SAP administration / development experts

View all SAP administration / development questions and answers

SearchERP

Last-mile delivery challenges in the age of omnichannel

The last-mile delivery problem is getting more difficult as customers demand lightning-speed product fulfillment. Here's hope.

Finance transformation efforts soar with cloud ERP

Although some CFOs resist moving financials to the cloud, the process can help streamline processes and save money. Here's a look...

Top 6 2020 supply chain trends

Supply chain technology is growing more complex and so are partnerships. Here are the most important trends leaders must ...

SearchOracle

Oracle Autonomous Database shifts IT focus to strategic planning

This handbook looks at what Oracle Autonomous Database offers to Oracle users and issues that organizations should consider ...

Oracle Autonomous Database features free DBAs from routine tasks

Oracle Autonomous Database can automate routine administrative and operational tasks for DBAs and improve productivity, but ...

Oracle co-CEO Mark Hurd dead at 62, succession plan looms

Oracle co-CEO Mark Hurd's abrupt death at 62 has put the software giant in the position of naming his replacement, and the ...

SearchDataManagement

Hitachi Vantara acquires data catalog vendor Waterline Data

With the acquisition of Waterline Data, Hitachi Vantara is bringing new data catalog capabilities that will expand the Lumada ...

New Confluent Platform release boosts event streaming quality

Based on the open-source Kafka event streaming platform, the Confluent Platform 5.4 update adds new capabilities to help meet ...

Where InfluxDB time series database is going

Users need more than SQL for querying databases, according to Paul Dix, co-founder and CTO of InfluxData. That's why the vendor ...

SearchAWS

New themed Amazon pop-up stores built on consumer data

In its never-ending quest to establish unique physical locations, Amazon has plans to launch a chain of themed pop-up stores that...

AWS security faces challenges after a decade of dominance

After a decade of dominating the public cloud market and influencing cloud security, AWS is faced with new challenges stemming ...

AWS AI tools focus on developers

AWS sells many AI products, tools and services aimed at developers, including several for AI newcomers, such as DeepRacer, ...

SearchBusinessAnalytics

How to compare and choose augmented analytics tools

Choosing an augmented BI and analytics vendor can be difficult when their offerings are so similar. Analysts at Gartner and ...

ThoughtSpot IPO could be coming after vendor adds first CFO

Hiring of a CFO for the first time signals that ThoughtSpot may be positioning itself for an IPO and comes six months after what ...

5 ways enterprises adapt to the data scientist shortage

Where are all the data scientists? Coping with the data scientist shortage is a struggle for many enterprises. Here are five ways...

SearchContentManagement

4 popular content collaboration platforms to consider

Companies need to be organized if they want to be efficient. Content collaboration platforms are useful, but first, ensure that ...

AI can enhance content security with a bit of planning

Microsoft and Box both use AI technologies to keep content secure in the cloud. But before using such tools, businesses first ...

Ex-SAP exec steers Episerver CMS toward digital experience market

Alex Atzberger discusses leaving the helm of SAP's CX platform to become Episerver CEO. Now, Episerver looks to reinvent itself ...

SearchHRSoftware

6 candidate journey mapping secrets savvy recruiters know

A journey map can be a critical tool for uncovering what it takes to provide your candidates with great experiences. Here's ...

Critical tips for managing contingent workers

Contingent workers save companies both time and money, so it's important to manage them in a win-win way. Here is what HR teams ...

Impact of AI on jobs goes on the presidential campaign trail

The impact of AI on jobs is a major issue for employers, who are struggling with how to address it. Robots, automation and AI ...

Re-log in to a sandbox client in ERP 5.0

Finding SAP tables in older releases during an upgrade

15. How can you reset SAP passwords?

Quiz: SAP security best practices

Please create a username to comment.