How to map object name in storage location grant to actual storage location

Sergey_Cherepan_1

Hi,

If you will do grant on storage location, in grants table you will see in column object_name values like __location_3_shared:

select distinct object_name from grants where object_type='STORAGELOCATION';

__location_3_shared
__location_4_shared

System view storage_locations do not have any references to this object_name.

I have a hard time figuring out map between object_name in grants and actual storage location.

Can you give a hint, how to find what __location_3_shared is referring to?

Vertica v 24.3.

Thank you
Sergey

SruthiA

please check vs_storage_locations table.

Sergey_Cherepan_1

Thanks!