SYSIBMADM.STORAGE_ACCESS_ALIAS.LIST table function

The SYSIBMADM.STORAGE_ACCESS_ALIAS.LIST table function lists the remote storage access aliases for which the caller has access.

Functionality is similar to that of the LIST STORAGE ACCESS CLP command. Unlike the CLP command, the table function only returns details for aliases for which the caller has permission to use.

Authorization

Users with EXECUTE privilege on the module SYSIBMADM.STORAGE_ACCESS_ALIAS have permission to use the LIST stored procedures to which they have access. All users that need access to remote storage aliases must have EXECUTE privilege on this module.

Syntax

Parameter descriptions

'CURRENT_USER': Filters the subset of aliases that the caller can use. If an argument is not provided, then 'CURRENT_USER' is the default.
NULL: A NULL value gives a user with DBADM or SYSADM privilege the ability to view an unfiltered list of all of the aliases.

Information returned

Table 1. Information returned by SYSIBMADM.STORAGE_ACCESS_ALIAS.LIST table function. Table of returned parameters, data type, and parameter description.
Parameter name	Data type	Description
alias	varchar(128)	Name of the alias.
vendor	varchar(30)	Type of the remote storage ('s3').
endpoint	varchar(255)	Authentication endpoint of the remote storage.
bucket	varchar(255)	Name of the bucket.
path	varchar(1024)	The name of or path to the object (file) on the remote storage.
granteetype	varchar(1)	The type of the grantee that may access the alias (U, G or R for user, group or role).
grantee	varchar(255)	The user id, group name or role that may access the alias.
usage	varchar(512)	Reserved for future use.

Example

Example of usage format:

select varchar(ALIAS, 128) as ALIAS,
       varchar(VENDOR, 30) as VENDOR,
       varchar(ENDPOINT, 255) as ENDPOINT,
       varchar(BUCKET, 255) as BUCKET,
       varchar(PATH, 1024) as PATH,
       GRANTEETYPE,
       varchar(GRANTEE, 255) as GRANTEE,
       varchar(USAGE, 512) as USAGE 
  from table(SYSIBMADM.STORAGE_ACCESS_ALIAS.LIST())