{"action":"created","issue":{"url":"https://api.github.com/repos/exasol/row-level-security/issues/6","repository_url":"https://api.github.com/repos/exasol/row-level-security","labels_url":"https://api.github.com/repos/exasol/row-level-security/issues/6/labels{/name}","comments_url":"https://api.github.com/repos/exasol/row-level-security/issues/6/comments","events_url":"https://api.github.com/repos/exasol/row-level-security/issues/6/events","html_url":"https://github.com/exasol/row-level-security/issues/6","id":522706591,"node_id":"MDU6SXNzdWU1MjI3MDY1OTE=","number":6,"title":"Password is exposed in EXPLAIN VIRTUAL for non local EXA connections","user":{"login":"exatobr","id":57671665,"node_id":"MDQ6VXNlcjU3NjcxNjY1","avatar_url":"https://avatars0.githubusercontent.com/u/57671665?v=4","gravatar_id":"","url":"https://api.github.com/users/exatobr","html_url":"https://github.com/exatobr","followers_url":"https://api.github.com/users/exatobr/followers","following_url":"https://api.github.com/users/exatobr/following{/other_user}","gists_url":"https://api.github.com/users/exatobr/gists{/gist_id}","starred_url":"https://api.github.com/users/exatobr/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/exatobr/subscriptions","organizations_url":"https://api.github.com/users/exatobr/orgs","repos_url":"https://api.github.com/users/exatobr/repos","events_url":"https://api.github.com/users/exatobr/events{/privacy}","received_events_url":"https://api.github.com/users/exatobr/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2019-11-14T08:44:47Z","updated_at":"2019-11-22T14:03:50Z","closed_at":null,"author_association":"NONE","body":"CREATE OR REPLACE CONNECTION EXASOL_CONNECTION \r\nTO 'jdbc:exa:localhost:8563'\r\nUSER 'sys' \r\nIDENTIFIED BY 'exasol';\r\n\r\nCREATE VIRTUAL SCHEMA RLS_VS USING VS_ADAPTER.RLS_ADAPTER WITH\r\n  SQL_DIALECT     = 'RLS'\r\n  CONNECTION_NAME = 'RLS_CONNECTION'\r\n  SCHEMA_NAME     = 'MY_RLS_TESTS'\r\n  ;\r\n\r\nCREATE VIRTUAL SCHEMA RLS_VS_2 USING VS_ADAPTER.RLS_ADAPTER WITH\r\n  SQL_DIALECT     = 'RLS'\r\n  CONNECTION_NAME = 'RLS_CONNECTION'\r\n  SCHEMA_NAME     = 'MY_RLS_TESTS'\r\n  IMPORT_FROM_EXA = 'true'\r\n  EXA_CONNECTION_STRING = 'localhost:8563';\r\n  ;\r\n\r\nCREATE VIRTUAL SCHEMA RLS_VS_3 USING VS_ADAPTER.RLS_ADAPTER WITH\r\n  SQL_DIALECT     = 'RLS'\r\n  CONNECTION_NAME = 'RLS_CONNECTION'\r\n  SCHEMA_NAME     = 'MY_RLS_TESTS'\r\n  IMPORT_FROM_EXA = 'true'\r\n  EXA_CONNECTION_STRING = 'localhost:8563'\r\n  IS_LOCAL = 'true'\r\n  ;\r\n\r\nexplain virtual SELECT * FROM rls_vs.TESTTAB2   t;\r\n--> no PW visible\r\n\r\nexplain virtual SELECT * FROM rls_vs_2.TESTTAB2   t;\r\n--> PW exposed\r\n\r\nexplain virtual SELECT * FROM rls_vs_2.TESTTAB2   t;\r\n--> no PW visible\r\n"},"comment":{"url":"https://api.github.com/repos/exasol/row-level-security/issues/comments/557543614","html_url":"https://github.com/exasol/row-level-security/issues/6#issuecomment-557543614","issue_url":"https://api.github.com/repos/exasol/row-level-security/issues/6","id":557543614,"node_id":"MDEyOklzc3VlQ29tbWVudDU1NzU0MzYxNA==","user":{"login":"AnastasiiaSergienko","id":46891819,"node_id":"MDQ6VXNlcjQ2ODkxODE5","avatar_url":"https://avatars2.githubusercontent.com/u/46891819?v=4","gravatar_id":"","url":"https://api.github.com/users/AnastasiiaSergienko","html_url":"https://github.com/AnastasiiaSergienko","followers_url":"https://api.github.com/users/AnastasiiaSergienko/followers","following_url":"https://api.github.com/users/AnastasiiaSergienko/following{/other_user}","gists_url":"https://api.github.com/users/AnastasiiaSergienko/gists{/gist_id}","starred_url":"https://api.github.com/users/AnastasiiaSergienko/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/AnastasiiaSergienko/subscriptions","organizations_url":"https://api.github.com/users/AnastasiiaSergienko/orgs","repos_url":"https://api.github.com/users/AnastasiiaSergienko/repos","events_url":"https://api.github.com/users/AnastasiiaSergienko/events{/privacy}","received_events_url":"https://api.github.com/users/AnastasiiaSergienko/received_events","type":"User","site_admin":false},"created_at":"2019-11-22T14:03:50Z","updated_at":"2019-11-22T14:03:50Z","author_association":"COLLABORATOR","body":"This is a known issue: https://github.com/exasol/virtual-schemas/issues/94"}}
{"actor":{"display_login":"AnastasiiaSergienko"}}