[EPIC] Verify DB System tables and tables where user do not have privileges are not accessible to the user at Airbyte UI

[alexandertsukanov]

Tell us about the problem you're trying to solve

The issue #5172 was found by the customer. Sometimes users have access to SYSTEM tables and tables where users do not have SELECT privileges at Airbyte UI (Connection setup step). As a result, we get a "Permission denied" runtime error, and the sync job crushes.

This issue is created to check if we don't have such issue in other source connectors.

Please, keep in mind, connector with blank Ticket OR Resolution column should be checked later.

Related issues:

Was able to reproduce the issue?	Source Connector	Ticket	Resolution
✔️	Postgres	#5172	PR created
✔️	DB2	#8171
✔️	MongoDB	#8752
	BigQuery	OOTB if user has read permissions for dataset, he automatically has permanent access to all tables #8844
	Amazon ADS
	Amazon Seller Partner
	Amazon SQS
	Amazon Seller Partner
	Amplitude
	Apify Dataset
	Appstore
	Asana
	AWS CloudTrail
	BambooHR
	Braintree
	BigCommerce
	Bing Ads
	Cart
	Chargebee
	ClickHouse
	Close.com
✔️	CockroachDB	#8868	#9004
	Dixa
	Drift
	Drupal
	Exchange Rates API
	Facebook Marketing
	Facebook Pages
	Files
	Freshdesk
	GitHub
	GitLab
	Google Ads
	Google Adwords
	Google Analytics v4
	Google Directory
	Google Search Console
	Google Sheets
	Google Workspace Admin Reports
	Greenhouse
	HubSpot
	Instagram
	Intercom
	Iterable
	Jira
	Klaviyo
	Klaviyo
	Lemlist
	LinkedIn Ads
	Linnworks
	Kustomer
	Lever Hiring
	Looker
	Magento
	Mailchimp
	Marketo
	MSSQL		Users don’t have access. Out of the box MSSQL doesn't provide access to the tables without SELECT grant.
	Microsoft Dynamics AX
	Microsoft Dynamics Customer Engagement
	Microsoft Dynamics GP
	Microsoft Dynamics NAV
	Microsoft Teams
	Mixpanel
	MySQL		Users don’t have access. Out of the box MySQL doesn't provide access to the tables without SELECT grant.
	Notion
	Okta
	OneSignal
	Oracle		Oracle DB - the schema is the user, you cannot REVOKE a privilege on a table from its owner. So fixing is not required.
	Oracle PeopleSoft
	Oracle Siebel CRM
	PayPal Transaction
	Paystack
	Pinterest
	Pipedrive
	Plaid
	PokéAPI
	PostHog
	PrestaShop
	Quickbooks
	Recharge
	Recurly
	Redshift
	S3
	Salesforce
	Salesloft
	SAP Business One
	Sendgrid
	Sentry
	Shopify
	Short.io
	Slack
	Spree Commerce
	Smartsheets
	Snowflake		snowflake handles case with permissions ootb, so user can see only tables where he has proper permissions
	Square
	Strava
	Stripe
	Sugar CRM
	SurveyMonkey
	Tempo
	TikTok Marketing
	Trello
	Twilio
	US Census
	WooCommerce
	Wordpress
	YouTube Analytics
	Zencart
	Zendesk Chat
	Zendesk Sunshine
	Zendesk Support
	Zendesk Talk
	Zoom
	Zuora