Hi All, I need your inputs in retrieving the login password in encoded format. I know we can use &sysuser to retrieve the login user. But for one requirement, we need to capture the login password as well. Could you please let me know if you have any idea on this.? I got the below code to retrieve the user/password for authentication domain..I think it wont be helpful for my requirement.. %macro Auth(AuthenticationDomain); %global Password UserID; data _null_; length uri UserId Password UserId AuthId AuthenticationDomain $256; rc=metadata_getnobj("omsobj:AuthenticationDomain?@Name='&AuthenticationDomain'",1,uri); rc=metadata_getattr(uri,"Id",AuthId); rc=1; tn=1; do while(rc>0); rc=metadata_getnasn("OMSOBJ:AuthenticationDomain\"!!AuthId,"Logins",tn,uri); if rc>0 then do; arc=metadata_getattr(uri,"UserID",UserID); arc=metadata_getattr(uri,"Password",Password); call symput("UserID",compress(UserID)); call symput("Password",compress(Password)); end; tn=tn+1; end; run; %put NOTE: For AuthenticationDomain &AuthenticationDomain., the UserID &UserID has password &Password.. Executed as &sysuserid..; %mend; %Auth(Oracle_BII) Thanks, Sampath
... View more