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

Details

    Description

      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

      Attachments

        Issue Links

          causes

          Bug - A problem which impairs or prevents the functions of the product. CONFSERVER-22480 Users and groups with multiple page permissions cannot be deleted on Oracle and SQL Server

          • Low - Low priority issues
          • Closed
          is caused by

          Bug - A problem which impairs or prevents the functions of the product. CONFSERVER-19914 Removing a page permission triggers a page delete operation

          • High - High priority issues
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. CONFSERVER-22356 Upgrading to 3.5.2 fails with Oracle 11

          • Medium - Medium priority issues
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. CONFSERVER-24031 Bad constraints on SQL Server

          • Low - Low priority issues
          • Closed

          Activity

            People

              nbhawnani Niraj Bhawnani
              akdominguez Katrina Walser (Inactive)
              Votes:
              2 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: