Table: linode_user - Query Linode Users using SQL

Linode Users represent individual users within a Linode account. Each user can have different permissions and access levels, depending on their role within the account. Users can be granted either unrestricted access to all Linode resources or restricted access to only certain resources.

Table Usage Guide

The linode_user table provides insights into individual users within a Linode account. As a system administrator, explore user-specific details through this table, including their usernames, emails, and whether they have restricted access. Utilize it to manage user permissions and access levels, ensuring the security and integrity of your Linode resources.

Examples

List users

Explore the list of users to understand who has access to your system, a crucial step in ensuring data security and managing user permissions.

select
  *
from
  linode_user;

select
  *
from
  linode_user;

Schema for linode_user

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
email	text		The email address for this User, for account management communications, and may be used for other communications as configured.
euuid	text		An external unique identifier for this account.
filter	text	=	Raw Linode list filter string in JSON format.
restricted	boolean		If true, this User must be granted access to perform actions or access entities on this Account.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
ssh_keys	jsonb		A list of SSH Key labels added by this User. These are the keys that will be deployed if this User is included in the authorized_users field of a create Linode, rebuild Linode, or create Disk request.
username	text	=	This User’s username. This is used for logging in, and may also be displayed alongside actions the User performs (for example, in Events or public StackScripts).

Export

This table is available as a standalone Exporter CLI. Steampipe exporters are stand-alone binaries that allow you to extract data using Steampipe plugins without a database.

You can download the tarball for your platform from the Releases page, but it is simplest to install them with the steampipe_export_installer.sh script:

/bin/sh -c "$(curl -fsSL https://steampipe.io/install/export.sh)" -- linode

You can pass the configuration to the command with the --config argument:

steampipe_export_linode --config '<your_config>' linode_user