Uploaded image for project: 'Confluence Data Center'
  1. Confluence Data Center
  2. CONFSERVER-22374

Some permissions cannot be added in SQL Server and Oracle

XMLWordPrintable

      CONF-19914 was fixed by adding unique constraints for various permission-related tables in the database. These constraints are interpreted differently in SQL Server, and may prevent permissions from being added to some pages.

      WORKAROUND:

      Stop your instance, run the following commands against your db, then restart.

      alter table CONTENT_PERM drop constraint cp_unique_user;
alter table CONTENT_PERM drop constraint cp_unique_group;
alter table CONTENT_PERM add constraint cp_unique_user_groups unique (cps_id, cp_type, username, groupname);

      NOTE 1: This does not apply to MySQL, PostgreSQL, nor DB2. Do not alter the constraints on these DBs or the fix for CONF-19914 will be reverted.
      NOTE 2: If you are using Oracle and upgraded to 3.5.2, AND have applied patch from CONF-22356 you do not need to apply the work around since it's already included in the patch. BUT, if this is a vanilla setup of 3.5.2 with Oracle then you NEED to apply the work around (unless you have applied CONF-22356 before installing).

      See also: http://confluence.atlassian.com/display/CONFKB/Cannot+add+or+edit+permissions+after+installing+or+upgrading+to+Confluence+3.5.2

            [CONFSERVER-22374] Some permissions cannot be added in SQL Server and Oracle

            Katherine Yabut made changes -
            Workflow Original: JAC Bug Workflow v3 [ 2898032 ] New: CONFSERVER Bug Workflow v4 [ 2992621 ]
            Owen made changes -
            Workflow Original: JAC Bug Workflow v2 [ 2790057 ] New: JAC Bug Workflow v3 [ 2898032 ]
            Status Original: Resolved [ 5 ] New: Closed [ 6 ]
            Owen made changes -
            Workflow Original: JAC Bug Workflow [ 2719955 ] New: JAC Bug Workflow v2 [ 2790057 ]
            Owen made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2389074 ] New: JAC Bug Workflow [ 2719955 ]
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5 [ 2266341 ] New: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2389074 ]
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5.1 - TEMP [ 2209975 ] New: Confluence Workflow - Public Facing - Restricted v5 [ 2266341 ]
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2195715 ] New: Confluence Workflow - Public Facing - Restricted v5.1 - TEMP [ 2209975 ]
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5 [ 1934226 ] New: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2195715 ]
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v3 [ 1733784 ] New: Confluence Workflow - Public Facing - Restricted v5 [ 1934226 ]
            Katherine Yabut made changes -
            Workflow Original: CONF Bug Subtask WF (TEMP) [ 1684938 ] New: Confluence Workflow - Public Facing - Restricted v3 [ 1733784 ]

              nbhawnani Niraj Bhawnani
              akdominguez Katrina Walser (Inactive)
              Affected customers:
              2 This affects my team
              Watchers:
              1 Start watching this issue

                Created:
                Updated:
                Resolved: