SELECT relname
FROM PG_CLASS_INFO
WHERE (upper(relname) LIKE 'STL_%' OR upper(relname) LIKE 'SVCS_%' OR upper(relname) LIKE 'SVL_%' OR upper(relname) LIKE 'SVV_%' OR upper(relname) LIKE 'STV_%' OR upper(relname) LIKE 'SYS_%')
AND has_table_privilege(relname,'SELECT') = 't';
relname
------------------------------------
svv_active_cursors
svv_datashares
svv_datashare_objects
svv_user_grants
svv_role_grants
svv_system_privileges
svv_relation_privileges
svv_function_privileges
svv_iam_privileges
svv_schema_privileges
svv_language_privileges
svv_database_privileges
svv_ml_model_privileges
svv_ml_model_info
svv_column_privileges
svv_datashare_privileges
svv_mv_info
svv_mv_dependency
svv_roles
svv_user_info
svv_default_privileges
svv_identity_providers
svv_datashare_consumers
svv_external_columns
svv_external_databases
svv_external_partitions
svv_external_schemas
svv_external_tables
svv_integration
svv_integration_table_mapping
svv_integration_table_state
svv_redshift_columns
svv_redshift_databases
svv_redshift_functions
svv_redshift_schema_quota
svv_redshift_schemas
svv_redshift_tables
svv_all_tables
svv_all_columns
svv_all_schemas
svv_table_info
svv_tables
svv_columns
svv_interleaved_columns
svv_rls_applied_policy
svv_rls_attached_policy
svv_rls_policy
svv_rls_relation
svv_masking_policy
svv_attached_masking_policy
svv_transactions
svv_alter_table_recommendations
svv_geometry_columns
svv_geography_columns
svv_copy_job_integrations
sys_analyze_compression_history
sys_analyze_history
sys_applied_masking_policy_log
sys_auto_table_optimization
sys_child_query_text
sys_connection_log
sys_copy_job
sys_copy_job_info
sys_copy_job_detail
sys_copy_replacements
sys_datashare_change_log
sys_datashare_cross_region_usage
sys_datashare_usage_consumer
sys_datashare_usage_producer
sys_datashare_write_history
sys_external_query_detail
sys_external_query_error
sys_integration_activity
sys_integration_table_activity
sys_integration_table_state_change
sys_load_detail
sys_load_history
sys_load_error_detail
sys_mv_refresh_history
sys_mv_state
sys_procedure_call
sys_procedure_messages
sys_query_detail
sys_query_explain
sys_query_history
sys_query_text
sys_restore_state
sys_restore_log
sys_result_offload_history
sys_schema_quota_violations
sys_session_history
sys_spatial_simplify
sys_stream_scan_errors
sys_stream_scan_states
sys_transaction_history
sys_udf_log
sys_unload_detail
sys_unload_history
sys_userlog
