on 09-20-2017 9:48 AM
I have a query regarding accessing HANA DB via putty.
DB team has created a user for me(say "X") with "MONITORING" role through which I am able to connect to HANA DB in studio.
OS team has created a user for me(say "Y") through which I am able to access server on which HANA DB is residing.
SO I want to know how and by which user can I access HANA DB in putty?
With Putty itself a direct access to the HANA DB is not possible. With Putty you can connect to the server on which HANA is running. If you logged in on OS level you can for instance use the hdbsql interface to connect to the HANA database with the DB user.
But the question is, what you wanna do. Depending on that you should choose the way and the tools how you access the db.
Regards,
Florian
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Florian,
Thanks for your input.
As of now, I want to check the current DB status in system and monitoring views, and the data collected by the statistics server. Also, load and memory consumption of OS, Run HDBSQl queries etc.
DB team is logging into the HANA DB via
su - <SIDADM>
and their entries is present cat /etc/group file.
So I want to know how can I I access HANA DB in putty via user that has "MONITORING" role.
User | Count |
---|---|
86 | |
10 | |
10 | |
9 | |
7 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.