Selecting a user role outside of the user's organization (Business Edition)

To select a role for a user that is different from the user's organization, do the following:

  1. Ensure that you have the following information:
    • The member ID of the user for which you are assigning the role, as defined in the USER_ID column of the USERS table.
    • The role ID for the role to which you want to assign the user, as defined in the ROLE_ID column of the ROLE table.
    • The organizational entity ID that represents the organization or organizational unit for which the user will play the role, as defined in the ORGENTITY_ID column of the ORGENTITY table.
      Note:
      You must first ensure that the organization has the role you want to use associated to it. You can do this by doing the following:
      1. Open the Organization Administration Console.
      2. From the Access Management menu, click Organizations. A list of organizations and organizational units for the site displays.
      3. From the list, select the check box next to organization name you want to work with, then click Roles to view or change the roles associated with the organization.
  2. Run the following SQL command:
    INSERT INTO MBRROLE (MEMBER_ID, ROLE_ID, ORGENTITY_ID) VALUES (member ID,
    role ID, organizational entity ID)
    

    where, member, ID, role ID, and organizational entity ID are the values you obtained in step 1.