This is an automated email from the ASF dual-hosted git repository.

morningman pushed a commit to branch branch-1.2-lts
in repository https://gitbox.apache.org/repos/asf/doris.git

commit ccbfbb2d426262a5bb49595d3a60edda768534ae
Author: yongkang.zhong <[email protected]>
AuthorDate: Sat Mar 18 22:21:01 2023 +0800

    [Improve](hana catalog)Currently logged in users should only see the 
schemas they can access (#17918)
    
    In the case of hana catalog, I think the current logged-in users should 
only see the schemas they can access.
---
 fe/fe-core/src/main/java/org/apache/doris/external/jdbc/JdbcClient.java | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git 
a/fe/fe-core/src/main/java/org/apache/doris/external/jdbc/JdbcClient.java 
b/fe/fe-core/src/main/java/org/apache/doris/external/jdbc/JdbcClient.java
index 08d4122126..d3b58f9355 100644
--- a/fe/fe-core/src/main/java/org/apache/doris/external/jdbc/JdbcClient.java
+++ b/fe/fe-core/src/main/java/org/apache/doris/external/jdbc/JdbcClient.java
@@ -191,7 +191,7 @@ public class JdbcClient {
                     rs = stmt.executeQuery("SELECT name FROM sys.schemas");
                     break;
                 case JdbcResource.SAP_HANA:
-                    rs = stmt.executeQuery("SELECT SCHEMA_NAME FROM 
SYS.SCHEMAS");
+                    rs = stmt.executeQuery("SELECT SCHEMA_NAME FROM 
SYS.SCHEMAS WHERE HAS_PRIVILEGES = 'TRUE'");
                     break;
                 default:
                     throw new JdbcClientException("Not supported jdbc type");


---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to