
	Home > Ask the SAP Experts > Upgrade/migration and Basis administration expert Questions & Answers > Unlocking a blocked admin user ID in an Oracle DB

Ask The SAP Expert: Questions & Answers

EMAIL THIS

Unlocking a blocked admin user ID in an Oracle DB

EXPERT RESPONSE FROM: Bert Vanstechelman

		Pose a Question

		Other SAP Categories

		Meet all SAP Experts
		Become an Expert for this site

Digg This!

StumbleUpon

Del.icio.us

QUESTION POSED ON: 14 May 2007
My admin user ID has been locked out. Is there a table I can update in Oracle to reset the flag and enable myself to log in?

EXPERT RESPONSE
Select all entries of table USR02 where 'UFLAG'=128. These users are locked by reason of incorrect logons. 'UFLAG'=64 will give you the users that are blocked by Administrator. Set 'UFLAG' to 0, to unlock your account.

Sound Off! -

Post your comments | See others' comments (1)

Digg This!

StumbleUpon

Del.icio.us

RELATED CONTENT

	Upgrade/migration and Basis administration expert
	Basis administration info in preparation for an interview
	Using transports from an ECC 5.0 system for config changes in 6.0
	RFC timeout problems
	Migrating SAP CRM 4.0
	SAPgui disconnection problem
	Building a new PRD system from an online backup
	Generating an SAP installation key
	Upgrading R/3 with smallest possible data loss
	Consolidating subsidiary companies to a single server
	Why are transport requests classified into workbench and customizing?

SAP authorization

What does the Parameter tab mean in SU01

Changing a customer message priority level after it's sent

Basis administration info in preparation for an interview

Easier maintenance of output types, procedures, conditions, etc.

Fixing inconsistencies in TemSe and Spool systems

On The Spot: Mario Linkies on SAP security

Listing TCODE transactions used to view what users are logged in to SAP

SAP's TCODE checks with the authorization tool

F_LFA1_APP and editing authorization restrictions

How do I restrict transaction access based on user profile?

RELATED RESOURCES

2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems

Search Bitpipe.com for the latest white papers and business webcasts

Whatis.com, the online computer dictionary

Search and Browse the Expert Answer Center
Search and browse more than 25,000 question and answer pairs from more than 250 TechTarget industry experts.

Browse our Expert Advice
Operating Systems IT Management Networking Database	Security Servers and Storage Applications and Development Career Center

SEARCH

TechTarget provides enterprise IT professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective IT purchase decisions and managing their organizations' IT projects - with its network of technology-specific Web sites, events and magazines.


TechTarget Corporate Web Site \| Media Kits \| Reprints \| Site Map All Rights Reserved, Copyright 2000 - 2008, TechTarget \| Read our Privacy Policy SearchSAP.com is a search service provided by TechTarget and is completely independent of and not affiliated with SAP AG.