Home

 

Change references to database administrative credentials

Update the aliases that reference the administrative user IDs and passwords used to manage Lotus Connections databases.


This is an optional procedure.

  1. Change the administrative user credentials using the tools provided with the database product that you are using.

    • DB2 Configuration Assistant

    • Oracle Enterprise Manager Console

    • SQL Server Management Studio

  2. To update the reference to the administrative user credentials that you just changed, change the credential information for the corresponding J2C authentication alias. In the WebSphere Application Server administration console, select Security > Secure Administration, applications and infrastructure.

  3. In the Authentication area, expand Java Authentication and Authorization Service, and click J2C authentication data.

  4. Click the alias name to edit it. Refer to the following tables for alias information.


    DB2 database user IDs and aliases

    Database user ID Alias Description
    LCUSER

    • activitiesJAASAuth

    • blogsJAASAuth

    • communitiesJAASAuth

    • dogearJAASAuth

    • filesJAASAuth

    • homepageJAASAuth

    • newsJAASAuth

    • profilesJAASAuth

    • wikisJAASAuth

    User ID of the user with a limited set of administrative privileges to access all of the feature tables in the DB2 database.


    Oracle database user IDs and aliases

    Database user ID Alias Description
    BLOGS blogsJAASAuth User ID of the user with a limited set of administrative privileges to access the Blogs table in the Oracle database.
    DOGEARUSER dogearJAASAuth User ID of the user with a limited set of administrative privileges to access the Bookmarks table in the SQL Server and Oracle databases.
    FILESUSER filesJAASAuth User ID of the user with a limited set of administrative privileges to access the Files table in the SQL Server and Oracle databases.
    HOMEPAGEUSER

    homepageJAASAuth

    newsJAASAuth

    searchJAASAuth

    User ID of the user with a limited set of administrative privileges to access the Home page table in the Oracle database. The same user ID administers the Home page, Search, and Updates services.
    OAUSER activitiesJAASAuth User ID of the user with a limited set of administrative privileges to access the Activities table in the SQL Server and Oracle databases.
    PROFUSER profilesJAASAuth User ID of the user with a limited set of administrative privileges to access the Profiles table in the SQL Server and Oracle databases.
    SNCOMMUSER communitiesJAASAuth User ID of the user with a limited set of administrative privileges to access the Communities table in the SQL Server and Oracle databases.
    WIKISUSER wikisJAASAuth User ID of the user with a limited set of administrative privileges to access the Wikis table in the SQL Server and Oracle databases.


    SQL Server database user IDs and aliases

    Database user ID Alias Description
    BLOGSUSER blogsJAASAuth User ID of the user with a limited set of administrative privileges to access the Blogs table in the SQL Server database.
    DOGEARUSER dogearJAASAuth User ID of the user with a limited set of administrative privileges to access the Bookmarks table in the SQL Server and Oracle databases.
    FILESUSER filesJAASAuth User ID of the user with a limited set of administrative privileges to access the Files table in the SQL Server and Oracle databases.
    HOMEPAGEUSER homepageJAASAuth, newsJAASAuth, searchJAASAuth User ID of the user with a limited set of administrative privileges to access the Home page table in the SQL Server database. The same user ID administers the Home page, Search, and Updates services.
    OAUSER activitiesJAASAuth User ID of the user with a limited set of administrative privileges to access the Activities table in the SQL Server and Oracle databases.
    PROFUSER profilesJAASAuth User ID of the user with a limited set of administrative privileges to access the Profiles table in the SQL Server and Oracle databases.
    SNCOMMUSER communitiesJAASAuth User ID of the user with a limited set of administrative privileges to access the Communities table in the SQL Server and Oracle databases.
    WIKISUSER wikisJAASAuth User ID of the user with a limited set of administrative privileges to access the Wikis table in the SQL Server and Oracle databases.

  5. Change the value in the Password field to reflect the change you made in Step 1.

  6. Apply and save the changes.

  7. Restart the servers hosting Lotus Connections.


Manage stored credentials


+

Search Tips   |   Advanced Search