Help Center> MapReduce Service> Component Operation Guide (LTS)> Using CarbonData> CarbonData FAQ> Why Missing Privileges Exception is Reported When I Perform Drop Operation on Databases?
Updated on 2023-04-28 GMT+08:00

Why Missing Privileges Exception is Reported When I Perform Drop Operation on Databases?

Question

Why drop database cascade is throwing the following exception?

Error: org.apache.spark.sql.AnalysisException: Missing Privileges;(State=,code=0)

Answer

This error is thrown when the owner of the database performs drop database <database_name> cascade which contains tables created by other users.