Attention
Zercurity has been acquired by JumpCloud.
This documentation will no longer be maintained or updated. You can read more about the acquisition, or signup to JumpCloud today.
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'