---
title: aioc.device _realm_view
slug: kronpam-how-to-guides-180/aiocdevice-realmview
description: This document offers a comprehensive table outlining user permissions for device access. Complete with user and device details such as ID, username, IP address, connection type, interface name, port, and group IDs, it serves to depict the correlation betw
docTags: 
createdAt: 2022-08-18T16:25:30.000Z
---

Shows which users have permission to access which devices.  

| Column             | Data Type              | Description                                                       |
| ------------------ | ---------------------- | ----------------------------------------------------------------- |
| db\_id             | bigint                 | Primary key of the table                                          |
| user\_id           | character varying(255) | User's id                                                         |
| user\_eid          | character varying(255) | Username                                                          |
| device \_dbid      | bigint                 | Device primary key                                                |
| device \_id        | character varying(255) | Device id                                                         |
| management\_ip     | character varying(255) | Device IP                                                         |
| access\_protocol   | character varying(255) | Connection type (MSSQL, ORACLE etc. )                             |
| interface\_name    | character varying(255) | Interface name defined on the device                              |
| Port               | character varying(255) | Port that can be connected                                        |
| user\_group\_id    | character varying(255) | Group id to which the real user is connected                      |
| device \_group\_id | character varying(255) | Group id of the connected device realm                            |
| device \_realm\_id | bigint                 | ID of the device realm connecting the User group and device group |