Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

database table to store all active user id's

Former Member
0 Kudos

hi all,

i want to know that which table stores all active user id . ie employee have user id they may leave the company so which table stores all valid user id which are now active.

thanks in advance.

Aditya Shrivastava.

1 ACCEPTED SOLUTION

Former Member

Active userIDs can be checked in table USR02.

Field GLTGV and GLTGB shows the validity date, system time should be in this interval to allow user login. Also userID should not be locked, field UFLAG should be '0'.

If above is not met, user will not be able to log in but get an error message.

Regards,

Krisz

3 REPLIES 3

JozsefSzikszai
Active Contributor
0 Kudos

USR01

Former Member

Active userIDs can be checked in table USR02.

Field GLTGV and GLTGB shows the validity date, system time should be in this interval to allow user login. Also userID should not be locked, field UFLAG should be '0'.

If above is not met, user will not be able to log in but get an error message.

Regards,

Krisz

Former Member
0 Kudos

check table USR02