Similar tragic story as other users have documented when being locked out of their apps. Here's my twist:
Without realizing that there are only two types of access: ADMIN and USER, I implemented section access, assigned user ids, passwords, and a 'cluster' column based on access levels that do not/can not exist.
By chance, the script included two lines for access type 'USER'. Unfortunately, the 'cluster' of data that the users should be able to view do not exist in the Section Application map.
I only have the latest version of the .qvw file available - no backup. When I try to publish the .qvw, the tasks fail. Am I really out of luck? Is it possible to create a custom access type? For example, 'EXECUTIVE' instead of 'ADMIN'.
Any suggestions would be greatly appreciated. Here's the script:
Section Access LOAD * INLINE [ ACCESS, USERID, PASSWORD, ID EXECUTIVE, EXEC, E, * CHANNEL_HEAD, CHAN, CH DEVELOPER, DEV, D, * USER, DEMO2, P, B USER, DEMO3, P, C ]
Section Application LOAD * INLINE [ Channel, ID RLO, R Other, O EJ, E M, M MO / SC, MOSC SM, SM WH, W