Hi All,
We newly setup SAS 9.4 and I have an issue with Login password not getting updated in SAS Management Console.
Details :
Let us say along with DefaultAuth I have multiple logins specified in my user account properties for different Auth Domains (like Oracle, Teradata).
OracleAuth <user-id> <password> TeradataAuth <user-id> <password>
For your reference, I am using the below program which helps retrieves the account id and encrypted password of the provided Authentication Domain.
%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;
Execute:
%Auth(TeradataAuth)
When I updated Login detail in the account as
TeradataAuth ABC mypass1
The macro gives result as NOTE: For AuthenticationDomain TeradataAuth, the UserID ABC has password {SAS002}ABCD3. Executed as Mark
When I updated Login detail in the account as
TeradataAuth ABC123 mypass2
The macro gives result as NOTE: For AuthenticationDomain TeradataAuth, the UserID ABC123 has password {SAS002}ABCD3. Executed as Mark
Which means the password I am giving is not updated at all but the change I made to user account works. Please help to resolve this issue.
Thanks Mark
... View more
