I am trying to create readonly user in ambari. I created a group provide the permission as cluster user but when i try to create folder or create or drop table in hive it is executing it and operations are performed. In one of the blog i read we should install ambari-server in remote server and register cluster as remote cluster and set hive views but still i have the same problem. Kindly help to resolve this
Cluster User : Users assigned to the Cluster User role can view information about the cluster and its services, including configurations, service status, and health alerts. In Ambari 2.2 and earlier, this user was referred to as the Read-only user. Effectively, the cluster user is a view-only user.
Regarding your query : When you are using a "cluster user" and try to create folder or create or drop table in hive it is executing it and operations are performed.
The Ambari Roles are permissions are applicable only for managing/accessing Ambari resources. These roles are not specific to the ACL of Hive / Hadoop.