Though i have set hive.security.authorization.enabled=true and hive.security.authorization.manager=org.apache.hadoop.hive.ql.security.authorization.plugin.sqlstd.SQLStdHiveAuthorizerFactory a User X can select table belonging to User Y as for some reason Spark SQL Thrift server is not doing authorization . This is causing the data security issue as User X can any select table though permissions are NOT granted. I did checked the same in Hive Thrift sever but there authentication is happening. Thanks for your help in advance and there is the argument passed while starting spark thrift server. I will appreciate if anyone of you can suggest a work around --hiveconf hive.security.authorization.manager=org.apache.hadoop.hive.ql.security.authorization.plugin.sqlstd.SQLStdHiveAuthorizerFactory --hiveconf hive.server2.enable.doAs=false --hiveconf hive.security.authorization.enabled=true --hive.server2.thrift.port=10001 --hiveconf xxxxhostname.compute.amazonaws.com --hiveconf hive.security.authenticator.manager=org.apache.hadoop.hive.ql.security.SessionStateUserAuthenticator -- View this message in context: http://apache-spark-user-list.1001560.n3.nabble.com/Authorisation-issue-in-Spark-while-using-SQL-based-Authorization-tp23619.html Sent from the Apache Spark User List mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: user-unsubscr...@spark.apache.org For additional commands, e-mail: user-h...@spark.apache.org