ERROR on Resetting Credentials on Imported SecuredLibrary Objects

[sathya66]

Hi,

We just upgraded environment so we imported some metabound libs from old to new env.

I tried to reset/modify the metadata bound lib password but I am getting ERROR/warning. I followed below link. am i missing anything?

https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/proc/n0v3rcwp7bnkbyn1hpm9sprxfdpi.htm#:~:text....

step 1 .

libname test "/sas/data/test" ;
ERROR: The secured library object information for the library test could not be obtained from the metadata server or has invalid data.
ERROR: There are no password associations for the secured library object. Perhaps the secured library object is newly imported. The Administrator must use the Authlib procedure to reset the passwords.
ERROR: Error in the LIBNAME statement.

Step 2:

libname test "/sas/data/test" authadmin=yes;
Note:Metadata permissions are not enabled.
WARNING: The secured library object information for library test could not be obtained  from the metadata server or has invalid data.
WARNING: There are no password associations for the secured library object. Perhaps the secured library object is newly imported. The Administrator must use the Authlib procedure to reset the passwords.
Note: Libref test was successfully assigned as follow:
Engine: V9
Physical path: /sas/data/test
secured Library: /System/Secured Libraries/test/test

Step 3:

proc authlib lib=test;
    modify  
        pw=secret 
        encrypt=aes ;
run;
quit;

Note: PROCEDURE AUTHLIB used (Total process time):
real time 0.02 seconds

Step 4; run the lib statement again getting the below ERROR same as step1

libname test "/sas/data/test" ;
ERROR: The secured library object information for the library test could not be obtained from the metadata server or has invalid data.
ERROR: There are no password associations for the secured library object. Perhaps the secured library object is newly imported. The Administrator must use the Authlib procedure to reset the passwords.
ERROR: Error in the LIBNAME statement.

I tried to modify the password from SMC but getting the same ERROR as above

[Steve_Huggins · Accepted solution]

Hi 

I've had similar issues in the past. If the tables are encrypted try:

libname test "/sas/data/test" authadmin=yes;

proc authlib lib=test;
  modify
    pw=secret
    require_encryption=yes
   encrypt=aes
   encryptkey=KEY;
run;
quit;

You might want to play around with the options. Also recommend deleting the entries from metadata and reimporting before. FYI SMC just runs the same code in the backgound so will give the same outcome.