ql/src/test/queries/clientnegative/authorization_sba_drop_table.q

set hive.metastore.pre.event.listeners=org.apache.hadoop.hive.ql.security.authorization.AuthorizationPreEventListener;
set hive.security.metastore.authorization.manager=org.apache.hadoop.hive.ql.security.authorization.StorageBasedAuthorizationProvider;

dfs ${system:test.dfs.mkdir} ${system:test.tmp.dir}/a_sba_droptab1;

create table t1(i int) location '${system:test.tmp.dir}/a_sba_droptab1';
dfs -chmod 555 ${system:test.tmp.dir}/a_sba_droptab1;
-- Attempt to drop table without having write permissions on table dir should result in error
drop table t1;