I want to create a new user that can remotely ssh into the server without having to ssh as a root user. And the new user should have limited access like can only read data from hive table, but can't modify the table or database. How can this be done? And for accessing remotely, is ssh only the option?
I tried to create a user via manage ambari, but that user is not shown on Ranger UI, and also i can't ssh using that user. Is there any good solution to this problem? Thank you