ST_SetAccessKey-AnalyticDB(AnalyticDB)-阿里云帮助中心

Sets the AccessKey credentials on a raster object to authenticate access to its data stored in Object Storage Service (OSS).

Prerequisites

The raster object is stored in OSS.

Syntax

raster ST_SetAccessKey(raster raster_obj, text id, text key, bool valid default true)

Parameters

Parameter	Description
raster_obj	The raster object to update.
id	The AccessKey ID used to log on to OSS. If set to NULL, the existing AccessKey ID is retained.
key	The AccessKey secret used to log on to OSS. If set to NULL, the existing AccessKey secret is retained.
valid	Specifies whether to verify the validity of the logon credentials. Default value: true.

Examples

UPDATE raster_table
SET rast = ST_SetAccessKey(rast, 'OSS_ACCESSKEY_ID', 'OSS_ACCESSKEY_SECRET');

SELECT ST_AKId(rast) from raster_table;
     st_akid
------------------
 OSS_ACCESSKEY_ID