Local system users encrypted passwords and related information. Please note, that you usually need superuser rights to access /etc/shadow.

Table schema

Name Type Description
password_status TEXT Password status
hash_alg TEXT Password hashing algorithm
last_change BIGINT Date of last password change (starting from UNIX epoch date)
min BIGINT Minimal number of days between password changes
max BIGINT Maximum number of days between password changes
warning BIGINT Number of days before password expires to warn user about it
inactive BIGINT Number of days after password expires until account is blocked
expire BIGINT Number of days since UNIX epoch date until account is disabled
flag BIGINT Reserved
username TEXT Username

Query examples

select * from shadow where username = 'root'