I have my python program which will connect using python dbapi and fetch the results :
import dbapi conn = dbapi.connect('linux',31515,'SYSTEM','*****')
cur=conn.cursor()
query="select GRANTEE,GRANTEE_TYPE,PRIVILEGE from GRANTED_PRIVILEGES "
ret = cur.execute(query)
ret = cur.fetchall()
I am validating the possibility of running it from non sidadm user.
Is it valid to run it from non sidadm user. Should that user have HANA env set up ?
What is the general process that should be followed ?
I have faced troubles in connecting with ssl enabled.
conn = dbapi.connect('linux.site',30015,'SYSTEM','*****',encrypt='True')
It works if I load the environment variables using -
". /usr/sap/<SID>/home/.sapenv.sh".
Is this the norm ?