shadow

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

Platform support

Please be aware that some queries can only be run against certain platforms. Below is a list of the supported platforms that this query supports. Zercurity will automatically pause queries from running if errors are detected. Running a query against an unsupported platform will result in the following error: no such table: shadow

  • Linux

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'