Difference between revisions of "ETK"
From SPGC Document Wiki
(→Reset ETK password) |
|||
| Line 5: | Line 5: | ||
# Run this query | # Run this query | ||
# UPDATE myleave.myuser SET password=md5("init1234") WHERE myusername="123456" | # UPDATE myleave.myuser SET password=md5("init1234") WHERE myusername="123456" | ||
| + | |||
| + | == Transfer Employee from RNF to VIP == | ||
| + | # Open SQL Yog connect to 52 server | ||
| + | # Get the employee number | ||
| + | # Run this query | ||
| + | # UPDATE myleave.olvemp SET emppccd=2 WHERE empnumb="123456" | ||
| + | |||
| + | # UPDATE myleave.myuser SET emppccd=2,myuseraccess="VIP" WHERE empnumb="123456" | ||
Revision as of 15:42, 14 June 2016
Reset ETK password
- Open SQL Yog connect to 52 server
- Get the employee number
- Run this query
- UPDATE myleave.myuser SET password=md5("init1234") WHERE myusername="123456"
Transfer Employee from RNF to VIP
- Open SQL Yog connect to 52 server
- Get the employee number
- Run this query
- UPDATE myleave.olvemp SET emppccd=2 WHERE empnumb="123456"
- UPDATE myleave.myuser SET emppccd=2,myuseraccess="VIP" WHERE empnumb="123456"
