BookmarkSubscribeRSS Feed
☑ This topic is solved. Need further help from the community? Please sign in and ask a new question.
YHelie1
Fluorite | Level 6

Hi,

 

Within a current SAS 9.4 deployment, we want to implement 'Integrated Windows Authentication' (IWA) with Active Directory. The source environment has SAS users created manually, with no User ID's related to Active Directory. Is there a way to import the users and then just run a script to update the User ID's (i.e. JSmith to AD Server\JSmith)?

 

Thank you!

1 ACCEPTED SOLUTION

Accepted Solutions
carl_sommer
SAS Employee

As @MarcoGhiglieri suggested, SAS provides macros and sample code for bulkload and synchronization of users between Active Directory and the SAS Metadata Server.

 

If you wish instead to have a program you can use to change the userid for the DefaultAuth login account (technically a Login metadata object, see SAS Namespace Types: Login :: SAS(R) 9.4 Metadata Model: Reference for properties and object associations), you could use the code in technical-support-code/usage/administration/sas-metadata-server/replace_metadata_login_case_s9.sas a... as an example.  This code changes the case of the userids for Login objects associated with a designated authentication domain.  But you could put your own code in place for the manner in which you wish to change the userid.

 

Carl Sommer - SAS Technical Support

View solution in original post

3 REPLIES 3
MarcoGhiglieri
Obsidian | Level 7

Hi! 
You can customize this to your needs: SAS Help Center: About the Sample Code for Active Directory

 

 

carl_sommer
SAS Employee

As @MarcoGhiglieri suggested, SAS provides macros and sample code for bulkload and synchronization of users between Active Directory and the SAS Metadata Server.

 

If you wish instead to have a program you can use to change the userid for the DefaultAuth login account (technically a Login metadata object, see SAS Namespace Types: Login :: SAS(R) 9.4 Metadata Model: Reference for properties and object associations), you could use the code in technical-support-code/usage/administration/sas-metadata-server/replace_metadata_login_case_s9.sas a... as an example.  This code changes the case of the userids for Login objects associated with a designated authentication domain.  But you could put your own code in place for the manner in which you wish to change the userid.

 

Carl Sommer - SAS Technical Support

YHelie1
Fluorite | Level 6

Hi Carl,

 

replace_metadata_login_case_s9.sas, that's EXACTLY what I was looking for!


Thx.

suga badge.PNGThe SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment. 

Join SUGA 

Get Started with SAS Information Catalog in SAS Viya

SAS technical trainer Erin Winters shows you how to explore assets, create new data discovery agents, schedule data discovery agents, and much more.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 3 replies
  • 799 views
  • 1 like
  • 3 in conversation