Manage Users with Shared Membership Configuration

Manage Users with Shared Membership Configuration

This question is answered

According to the Administrator's Guide users should be created when Shared Membership or Windows Authentication is used. However, when we configured Shared Membership and it appears to be working, we still do not see the users in the Select Users box in Manage Users admin page. The administrator account for Telligent Analytics has both Everyone and HarvestAdmin role assigned. I wonder why there is still HarvestAdmin role and if the HarvestAdmin role is the default admin role for Analytics. Please help get the users populated in the Select Users box in the Manage Users page. We need to assign roles to those users. Thank you very much.

Verified Answer
  • Hi Dorine,

    There is method for importing the users ahead of time that you could try.  If you look in the database for Telligent Analytics you will see a table called rs_Users.  If you fill this table with users from your shared membership store you should be able to assign them roles just as if they had already logged in.  

    There are a couple things you need to be aware of though:

    - The username and email must match what is in shared membership exactly (the text and casing must match).   This is very important as otherwise a user might not receive the correct roles when signing in.

    - Once you populate the rs_users table you will need to recycle the application to make sure the cache is refreshed from the database.  The easiest way to do this is to touch the web.config or recycling the AppPool and Web Site.  

    - Once this is done, you should be able to manage users from the Manage Users page in settings.  

    Thank You,

    Scott

  • Thank you Scott!
     
    Tim and Xander, here is a workaround provided by Scott. I'll test the Windows Authentication first before trying this.
     
    Thanks.
     
    Dorine
     

    From: ssargent [bounce-ssargent@communities.telligent.com]
    Sent: Friday, November 20, 2009 4:22 PM
    To: install_analytics@communities.telligent.com
    Subject: Re: [Installation and Configuration - Telligent Analytics] Manage Users with Shared Membership Configuration

    Hi Dorine,

    There is method for importing the users ahead of time that you could try.  If you look in the database for Telligent Analytics you will see a table called rs_Users.  If you fill this table with users from your shared membership store you should be able to assign them roles just as if they had already logged in.  

    There are a couple things you need to be aware of though:

    - The username and email must match what is in shared membership exactly (the text and casing must match).   This is very important as otherwise a user might not receive the correct roles when signing in.

    - Once you populate the rs_users table you will need to recycle the application to make sure the cache is refreshed from the database.  The easiest way to do this is to touch the web.config or recycling the AppPool and Web Site.  

    - Once this is done, you should be able to manage users from the Manage Users page in settings.  

    Thank You,

    Scott



All Replies
  • Hello Dorine,

    User Accounts in Analytics are not created until the user logs in for the first time. Have you successfully logged in using the shared membership account?

    Do you see user accounts for those users who have logged in, or none at all?

    Yes, "HarvestAdmin" is the default admin role in Analytics 3.0.

  • Hello,  

    I will be taking a look at this and will reply back shortly with more information. 

    Thank you

    Scott

  • Thank you for the reply Andrew. I didn't know that only when a user logs on the first time, the user account is created. This will present a problem for us because we need to assign roles to users to limit the user access to reports before we would want users to log on. I'm working on a development copy of Community and Analytics; so I'm the only one logging on now. I'm able to see my user account in the Select Users box. However, we need to be able to assign user roles before users can log on and we need to resolve it before we release Analytics to our pubic users. Can we import the users from the Analytics or Community database so that we can assign roles to the users before they are able to log on?

    Thank you again.

  • Hi Dorine,

    There is method for importing the users ahead of time that you could try.  If you look in the database for Telligent Analytics you will see a table called rs_Users.  If you fill this table with users from your shared membership store you should be able to assign them roles just as if they had already logged in.  

    There are a couple things you need to be aware of though:

    - The username and email must match what is in shared membership exactly (the text and casing must match).   This is very important as otherwise a user might not receive the correct roles when signing in.

    - Once you populate the rs_users table you will need to recycle the application to make sure the cache is refreshed from the database.  The easiest way to do this is to touch the web.config or recycling the AppPool and Web Site.  

    - Once this is done, you should be able to manage users from the Manage Users page in settings.  

    Thank You,

    Scott

  • Thank you Scott!
     
    Tim and Xander, here is a workaround provided by Scott. I'll test the Windows Authentication first before trying this.
     
    Thanks.
     
    Dorine
     

    From: ssargent [bounce-ssargent@communities.telligent.com]
    Sent: Friday, November 20, 2009 4:22 PM
    To: install_analytics@communities.telligent.com
    Subject: Re: [Installation and Configuration - Telligent Analytics] Manage Users with Shared Membership Configuration

    Hi Dorine,

    There is method for importing the users ahead of time that you could try.  If you look in the database for Telligent Analytics you will see a table called rs_Users.  If you fill this table with users from your shared membership store you should be able to assign them roles just as if they had already logged in.  

    There are a couple things you need to be aware of though:

    - The username and email must match what is in shared membership exactly (the text and casing must match).   This is very important as otherwise a user might not receive the correct roles when signing in.

    - Once you populate the rs_users table you will need to recycle the application to make sure the cache is refreshed from the database.  The easiest way to do this is to touch the web.config or recycling the AppPool and Web Site.  

    - Once this is done, you should be able to manage users from the Manage Users page in settings.  

    Thank You,

    Scott