topic Can you pre-populate user accounts for Share using SQL? in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/can-you-pre-populate-user-accounts-for-share-using-sql/m-p/229492#M182622 <HTML><HEAD></HEAD><BODY><SPAN>I have Alfresco share working with passthru back to Windows for authentication. This works wonderfully. User accounts are automatically created when a user first comes logs on to Alfresco Share. My question is:</SPAN><BR /><BR /><SPAN>I am already using a CIFS share that is tied to a public group. Users who try to connect to the share, but who have never logged in to Alfresco Share, cannot connect. Once they have an account, they are fine.</SPAN><BR /><BR /><SPAN>Instead of having every user log on once to create the Alfresco user, is there an easy way to pro-populate the user accounts using SQL? I noticed a table named alf_authority. Can I simply create my list of paasthru users in this table? I can handle making the unique id filed, but how do I populate the CRC field? Are there other tables that would also need to be updated?</SPAN><BR /><BR /><SPAN>Thanks in advance</SPAN></BODY></HTML> Fri, 15 Jan 2010 14:25:48 GMT ghicky 2010-01-15T14:25:48Z Can you pre-populate user accounts for Share using SQL? https://connect.hyland.com/t5/alfresco-archive/can-you-pre-populate-user-accounts-for-share-using-sql/m-p/229492#M182622 I have Alfresco share working with passthru back to Windows for authentication. This works wonderfully. User accounts are automatically created when a user first comes logs on to Alfresco Share. My question is:I am already using a CIFS share that is tied to a public group. Users who try to connect t Fri, 15 Jan 2010 14:25:48 GMT https://connect.hyland.com/t5/alfresco-archive/can-you-pre-populate-user-accounts-for-share-using-sql/m-p/229492#M182622 ghicky 2010-01-15T14:25:48Z Re: Can you pre-populate user accounts for Share using SQL? https://connect.hyland.com/t5/alfresco-archive/can-you-pre-populate-user-accounts-for-share-using-sql/m-p/229493#M182623 <HTML><HEAD></HEAD><BODY><SPAN>You need to use LDAP to sync the user accounts across. See </SPAN><A href="http://wiki.alfresco.com/wiki/Alfresco_Authentication_Subsystems#LDAP" rel="nofollow noopener noreferrer">http://wiki.alfresco.com/wiki/Alfresco_Authentication_Subsystems#LDAP</A></BODY></HTML> Thu, 04 Mar 2010 22:05:18 GMT https://connect.hyland.com/t5/alfresco-archive/can-you-pre-populate-user-accounts-for-share-using-sql/m-p/229493#M182623 zaizi 2010-03-04T22:05:18Z