
	Home > Ask the SAP Experts > Upgrade/migration and Basis administration expert Questions & Answers > Using Oracle passwords with SAP

Ask The SAP Expert: Questions & Answers

EMAIL THIS

Using Oracle passwords with SAP

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: 27 August 2006
Which SAP user communicates with Oracle internally? Does SAP use the password of ora<sid> or <sid>adm to communicate with Oracle?

Thanks.

EXPERT RESPONSE
During normal operation, SAP does not use the ora<sid> or <sid>adm user to connect to the database. All SAP tables are owned by the database user SAPR3 (or SAP<SID> as of SAP release 6.20). The password of this user is stored in the database table SAPUSER owned by <sid>adm.

At startup, SAP first connects as user <sid>adm to the database. It retrieves the password entry from the SAPUSER table and then re-connects using the SAPR3 user with the correct password. The password of user SAPR3 should therefore always be changed with SAPDBA or BRTOOLS instead of using the standard Oracle tools.

This setup is explained in detail in the Database Security for Oracle white paper which is available for download at the SAP Developer Network (http://sdn.sap.com).

Digg This!

StumbleUpon

Del.icio.us

RELATED CONTENT

	Upgrade/migration and Basis administration expert
	SAP roles and buffer space
	Upgrading from SAP ECC 4.7
	Error when clicking the SAP GUI logon button
	'Best Practice' add-on problems when upgrading to ECC 6.0
	Clicking on the SAPGUI logon button brings error message
	SAP R/3 to ERP 6.0: Upgrade the network infrastructure?
	Using transports from ECC 5.0 to make config changes in 6.0
	SAP administration information for a Basis interview
	Basis administration info in preparation for an interview
	Using transports from an ECC 5.0 system for config changes in 6.0

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.