-
Products and Technology
By Category
-
Groups
Activity Groups
Industry Groups
Influence and Feedback Groups
Interest Groups
Location Groups
Customer Only Groups
- Developers
- Partners
- Events
- Help Center
- Topic Pages
-
Explore SAP
Products
Learning and Support
-
- Products and Technology
- Groups
- Developers
- Partners
- Events
- Help Center
- Topic Pages
-
Explore SAP
- Explore SAP
-
Products
- Products
- SAP Business Suite
- Artificial Intelligence
- Business applications
- Data and analytics
- Technology Platform
- Financial Management
- Spend Management
- Supply Chain Management
- Human Capital Management
- Customer Experience
- SAP Business Network
- View products A-Z
- View industries
- Try SAP
- Partners
- Services
- Learning and Support
- About
- SAP Community
- Groups
- Interest Groups
- Application Development and Automation
- Discussions
- Fields in USR02 table ?
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Fields in USR02 table ?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎2007 Jul 18 7:51 PM
- SAP Managed Tags
- Security
What is the significance of TRDAT (Last logon date) column of USR02 table ? For any user if these column shows 00/00/0000 does it mean that this user has <b>"never logged in to that system"</b> after creation of his id ?
Whether any lock/unlock,password reset etc activities can reset TRDAT value to 00/00/0000 ?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎2007 Jul 18 7:58 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎2007 Jul 18 7:56 PM
- SAP Managed Tags
- Security
sapman,
USR02 fields PWDLGNDATE PWDSETDATE are updated when a users password is changed.
Cheers,
Ben
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎2007 Jul 18 7:58 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎2007 Jul 18 9:11 PM
- SAP Managed Tags
- Security
If a user has logged on and then their password is reset or lock / unlock, it will not change the values in TRDAT. Only way to get those values back to 00/00/0000 is to delete and re-create the user .
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎2007 Jul 20 4:25 PM
- SAP Managed Tags
- Security
Please use only the available APIs.
Never (try to interpret or) evaluate contents of database tables.
The structure of table USR02 has been changed many times - and will continue to be subject of changes.
PS: do not pay much attention to those who pretend to be "experts" - believe me: they do not know all the internals which are required to implement it the right way.
Bluesky