facing issue of permission denied to select from foreign table in security mode ?
- I TRIED TO ASSIGN USER SAME ROLE AS DBADMIN.
- I tried to assign permission on given schema, table
- granted permission on all schema/specific schema
- granted permission on all tables/specific table
The user mapping between local user and foreign server user can be done with AK/PK ? or it is required to use with username and password only
Still getting similar errorrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrr
