how to grant the privilege to database using The SQL standards based authorization in hive

[#1]

My requirement is database x has only access to user1 and database y only have the access to user2 using hive2 sql based Authorization model.

1. As per SQL standards authorization in hive documentation select,delete,update,insert privileges unable to grant database then how to grant the privileges at database level ?

[#2]

@Vijay Kiran

First thing is to enable 'SQLStdAuth' for Hive authorization. Refer to Apache link for more details.

[#3]

by following the Apache link by changing the ownership of the database to role, we can grant the privileges. I followed these steps

create role a;

ALTER DATABASE x SET OWNER ROLE a;

can any help to proceed further steps towards the granting privileges to database x;

Thanks a lot.

[#4]

@Sindhu it was not secured

[#5]

by following the Apache link by changing the ownership of the database to role, we can grant the privileges. I followed these steps

create role a;

ALTER DATABASE x SET OWNER ROLE a;

can any help to proceed further steps towards the granting privileges to database x;

Thanks a lot.