SQLite Cloud

LIST ALLOWED IP

Syntax

LIST ALLOWED IP [ROLE role_name] [USER user_name]

Privileges

USERADMIN

Description

The LIST ALLOWED IP returns a rowset that contains all the IP restrictions associated with a given ROLE and/or USER. If no ROLE/USER is specified, then all the IP restrictions table is returned.

Return

A Rowset with the following columns:

  • address: IP address(es) allowed
  • name: user name or role name
  • type: user or role String

Example

> LIST ALLOWED IP
------------|-------|------|
 address    | name  | type |
------------|-------|------|
192.168.1.1 | user1 | user |
------------|-------|------|