Home > SAP Tips > Basis administration > Non-expiring password
SAP Tips:
EMAIL THIS
 TIPS & NEWSLETTERS TOPICS 

BASIS ADMINISTRATION

Non-expiring password


Fr?Ric Dumay
06.14.2004
Rating: -4.00- (out of 5) Hall of fame tip of the month winner


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   


You use the parameter login/password_expiration_time because you want users to change their password every xx days. However, you want it so that some users don't have to change their password. At database level (not in R/3), you can easily solve this problem: in the table USR02, just set a date far in the future for the field BCDA1 (password last change). For example, if you want to set it so user SMITH does not have to change his password until 2010, you can use the following SQL script : update USR02 set BCDA1 = '20101231' where BNAME='SMITH' Just replace the values for BCDA1 and BNAME with your own values ! This script is for MS SQL Server + R/3 46B and 46C, but the syntax should not be very different for other database systems and R/3 versions.

Rate this Tip
To rate tips, you must be a member of SearchSAP.com.
Register now to start rating these tips. Log in if you are already a member.


Submit a Tip




Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   


RELATED CONTENT
Basis administration
Select Text fields: Case-insensitive
Finding BADIs you can use
Easier maintenance of output types, procedures, conditions, etc.
Is this the quickest way to find a BADI?
Top 10 SAP tips of 2007
Dealing with backup server instability
SAP security audit log setup
Do not use SAP GUI with Internet Explorer 7 Beta
How to reinstall the Support Package Manager from the command line in SAP Basis
Display locked and unlocked SAP transactions

SAP Basis
Error when clicking the SAP GUI logon button
The difference between an SAP system and a non-SAP system
Becoming an SAP administrator: The self-study route
Basis consultant wants to learn NetWeaver Portal
SAP administration information for a Basis interview
SAP ABAP development quiz
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.
SAP Basis Research

SAP security
The difference between an SAP system and a non-SAP system
SAP administration information for a Basis interview
SAP ABAP development quiz
Restricting sales document assignments by sales area
Authorization objects with a value of single/double quote marks
Error logging in using a reference ID
Easier maintenance of output types, procedures, conditions, etc.
Security risk: Users able to see data from other companies
Assigning roles to all users in a group
On The Spot: Mario Linkies on SAP security

RELATED GLOSSARY TERMS
Terms from Whatis.com − the technology online dictionary
Basis  (SearchSAP.com)

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

DISCLAIMER: Our Tips Exchange is a forum for you to share technical advice and expertise with your peers and to learn from other enterprise IT professionals. TechTarget provides the infrastructure to facilitate this sharing of information. However, we cannot guarantee the accuracy or validity of the material submitted. You agree that your use of the Ask The Expert services and your reliance on any questions, answers, information or other materials received through this Web site is at your own risk.



NetWeaver SAP White Papers
HomeNewsTopicsBlogsTipsAsk the ExpertsMultimediaWhite PapersProducts
About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
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.
  TechTarget - The IT Media ROI Experts