Hi All,
I am looking out for suggestion and if any solution been done for below requirment.
I have a Oracle Library in SMC called "cust" with SAS group cust_users which has been updated with Oracle access account to connect in SAS SMC.
Auth: OraAuth
UserID -:scott
Password : pw, added users(tom, eric) to this group as members to allow accessing the DB.
Users are able to access oracle tables using cust library and the connection to oracle using scott user id and pw.
I want to pass the user id's tom and eric user id along with oracle account scott while connecting to oracle database to user audit purpose.
like when user access customer library, the access request shoud register in oracle like below
scott_tom and scott_eric.
Is that possible to add ant variable in SAS to suffix the user account to oracle access account while connecting to oracle DB?
Thanks,
CS