users¶
Local system users.
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: users
- Windows
- Linux
- Mac OSX
- Free BSD
Table schema¶
Name | Type | Description |
---|---|---|
uid | BIGINT | User ID |
gid | BIGINT | Group ID (unsigned) |
uid_signed | BIGINT | User ID as int64 signed (Apple) |
gid_signed | BIGINT | Default group ID as int64 signed (Apple) |
username | TEXT | Username |
description | TEXT | Optional user description |
directory | TEXT | User’s home directory |
shell | TEXT | User’s configured default shell |
uuid | TEXT | User’s UUID (Apple) |
type | TEXT | Whether the account is roaming (domain), local, or a system profile |
Query examples¶
select * from users where uid = 1000
select * from users where username = 'root'
select count(*) from users u, user_groups ug where u.uid = ug.uid