WAXPerm Ops

Column Descriptions

for wax.perm_ops

20 rows

Name	Type	Description
id	NUMBER
owner	TEXT
action_index	NUMBER
keys_weight	ARRAY
block_date	DATE
name	TEXT
parent_id	NUMBER
tx_hash	TEXT
wait_sec	ARRAY
block_number	NUMBER
threshold	NUMBER
block_time	TIMESTAMP_NTZ
keys_public_key	ARRAY
operation	TEXT
tx_success	BOOLEAN
accounts_weight	ARRAY
wait_weight	ARRAY
accounts	ARRAY
operation_code	NUMBER
block_hash	TEXT

Sample Queries

Find Permissions for a Specific Account

Retrieves all permission changes related to a specific account

SELECT
  *
FROM
  wax.perm_ops
WHERE
  owner = 'someaccount';

Most Common Permission Changes

Identifies the most common types of permission operations

SELECT
  operation,
  COUNT(*) AS operation_count
FROM
  wax.perm_ops
GROUP BY
  operation
ORDER BY
  operation_count DESC
LIMIT
  10;

Accounts with Multiple Permission Changes in a Block

Finds accounts that had multiple permission changes within the same block

SELECT
  block_number,
  owner,
  COUNT(*) AS changes
FROM
  wax.perm_ops
GROUP BY
  block_number,
  owner
HAVING
  changes > 1
ORDER BY
  changes DESC;