Uploaded image for project: 'Crowd Data Center'
  1. Crowd Data Center
  2. CWD-5165

Description of insert query to cwd_granted_perm in "Restoring Passwords..." outdated

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Low
    • None
    • None
    • Documentation
    • None

    Description

      Problem Definition

      The insert query to cwd_granted_perm written in the page Restoring Passwords To Recover Admin User Rights is outdated. The query fails due to a lack of a column.

      INSERT INTO cwd_granted_perm(ID, created_date, permission_id, group_mapping) 
      VALUES (999999, '<current time (i.e. 2015-09-25 12:08:00)', 2, 898990);
      

      Suggested Solution

      It should have app_dir_mapping_id column in its query.

      insert into cwd_granted_perm (id, created_date, permission_id, app_dir_mapping_id, group_name)
       values (999999, '<current time (i.e. 2015-09-25 12:08:00)', 2, <id from step "e" >,898990);
      

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              nmukai Nobuyuki Mukai
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: