EOSPerm Ops

Column Descriptions

for eos.perm_ops

20 rows

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

Sample Queries

Find Permissions for a Specific Account

Retrieves all permission changes related to a specific account

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

Most Common Permission Changes

Identifies the most common types of permission operations

SELECT
  operation,
  COUNT(*) AS operation_count
FROM
  eos.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
  eos.perm_ops
GROUP BY
  block_number,
  owner
HAVING
  changes > 1
ORDER BY
  changes DESC;