Solutions
Device management
Remotely manage, and protect laptops and mobile devices.
Orchestration
Automate tasks across devices, from app installs to scripts.
Software management
Inventory, patch, and manage installed software.
Extend Fleet
Integrate your favorite tools with Fleet.
Customers
Stripe + Fleet
Stripe consolidates multiple tools with Fleet.
Foursquare + Fleet
Foursquare quickly migrates to Fleet for device management.
What people are saying
Stories from the Fleet community.
Pricing
More
Tables
Fleet uses osquery tables to query operating system, hardware, and software data. Each table provides specific data for analysis and filtering.
Apple
Linux
Windows
ChromeOS
authdb
authdb
The macOS authorizationdb is used by Mac admins to give their users or themselves granular permissions on the Macs they manage. The authdb osquery table returns JSON output for the authorizationdb read <right_name> command.
| Column | Type | Description |
|---|---|---|
| json_result | text | The JSON output parsed from authorizationdb plist. |
| right_name | text | The right_name to query in the authorizationdb read <right_name> command.Required in WHERE clause |
Example
The “right_name” string system.login.console is used in the mandatory WHERE clause for this table:
SELECT * FROM authdb WHERE right_name='system.login.console';Notes
This table is from the Mac Admins osquery extension.
The authorizationdb is a SQLite database that can be dumped out with the following Terminal command:
sudo /usr/bin/sqlite3 /var/db/auth.db .dumpThe following command generates a .plist showing the attributes of the authorizationdb configuration:
security authorizationdb read system.login.console- Apple documentation
- A general purpose authorizationdb article
- Armin Briegel (Scripting OS X) on the macOS root user and the authorizationdb
- Elliot Jordan on using the authorizationdb in his tool Escrow Buddy
Questions?
SOC2 Type 2
