Users don't show up in Reset Operators Passwords

I believe the Reset Operators Passwords form (under Reports) was something that originated in the Shared Reports Workspace of TASK under Public Knowledge Base Solution 290 although I was not here at the time and I'm pretty new to Tessitura.

We have an issue where certain users just don't show up in the dropdown. Does anybody have any experience with this issue, and if so, what user setting might be causing users to just not show up? We could reset the password using Tessitura Security, but the user's supervisor needed to do it off hours and couldn't.

Thanks in advance for any help.

 

Parents
  • Thanks Brian. We don’t have that table. I was hopeful, but I just checked in SSMS after not seeing it in system tables.

     

    FYI we are in v11.04 getting ready to upgrade to v12.5.

     

    Jerry Boutot | Manager of Database Administration | gerald.boutot@strazcenter.org

    David A. Straz, Jr. Center for the Performing Arts |

    1010 North W.C Macinnes Pl | Tampa, Florida 33602
    O: 813.222.1097 C: 352-428-4199

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Brian Wilbur Grundstrom
    Sent: Tuesday, April 26, 2016 12:29 PM
    To: Boutot, Gerald <Gerald.Boutot@strazcenter.org>
    Subject: RE: [Tessitura Technical Forum] Users don't show up in Reset Operators Passwords

     

    The version of the password reset I have relies on system table LTR_SECURITY_PW_RST to assign the security of whose passwords one can reset.

     

     

    BRIAN WILBUR GRUNDSTROM | Database Administrator
    SHAKESPEARE THEATRE COMPANY
    Recipient of the 2012 Regional Theatre Tony Award®

    516 Eighth Street, SE | Washington, DC 20003-2834
    p 202.547.3230 ext. 2216 | c 917.952.7957
    bwg@shakespearetheatre.org
    www.shakespearetheatre.org
    www.brianwilbur.com
    2015|2016 SEASON •• Farber’s SALOMÉ • Porter’s  KISS ME, KATE • Hatcher’s THE CRITIC & Stoppard’s THE REAL INSPECTOR HOUND • Shakespeare’s OTHELLOOrwell’s 1984 • Shakespeare’s THE TAMING OF THE SHREW

     

     

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Nick Reilingh
    Sent: Thursday, April 21, 2016 10:08 AM
    To: Brian W. Grundstrom
    Subject: Re: [Tessitura Technical Forum] Users don't show up in Reset Operators Passwords

     

    Users don't have managers assigned to them. Users are assigned to groups, and then other users are assigned to manage those groups.

    I will offer that I made a version of a password reset utility that is shared via the bitbucket site (https://bitbucket.org/TN_WebShare/password-reset-utility) — email web_dev@tessituranetwork.com for access. One of the benefits of using a collaborative platform like Bitbucket is that everyone has visibility on the code and can submit enhancements or bugfixes to it. If you feel like switching over to that version, I'll be happy to help solve any problems if you encounter them.

    From: Gerald Boutot <bounce-geraldboutot3782@tessituranetwork.com>
    Sent: 4/21/2016 8:41:28 AM

    Thanks Beau. I did some investigating and found that many users that show up in the drop-down have no Manager assigned! And some that don't show up have a manager assigned.




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

       

Reply
  • Thanks Brian. We don’t have that table. I was hopeful, but I just checked in SSMS after not seeing it in system tables.

     

    FYI we are in v11.04 getting ready to upgrade to v12.5.

     

    Jerry Boutot | Manager of Database Administration | gerald.boutot@strazcenter.org

    David A. Straz, Jr. Center for the Performing Arts |

    1010 North W.C Macinnes Pl | Tampa, Florida 33602
    O: 813.222.1097 C: 352-428-4199

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Brian Wilbur Grundstrom
    Sent: Tuesday, April 26, 2016 12:29 PM
    To: Boutot, Gerald <Gerald.Boutot@strazcenter.org>
    Subject: RE: [Tessitura Technical Forum] Users don't show up in Reset Operators Passwords

     

    The version of the password reset I have relies on system table LTR_SECURITY_PW_RST to assign the security of whose passwords one can reset.

     

     

    BRIAN WILBUR GRUNDSTROM | Database Administrator
    SHAKESPEARE THEATRE COMPANY
    Recipient of the 2012 Regional Theatre Tony Award®

    516 Eighth Street, SE | Washington, DC 20003-2834
    p 202.547.3230 ext. 2216 | c 917.952.7957
    bwg@shakespearetheatre.org
    www.shakespearetheatre.org
    www.brianwilbur.com
    2015|2016 SEASON •• Farber’s SALOMÉ • Porter’s  KISS ME, KATE • Hatcher’s THE CRITIC & Stoppard’s THE REAL INSPECTOR HOUND • Shakespeare’s OTHELLOOrwell’s 1984 • Shakespeare’s THE TAMING OF THE SHREW

     

     

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Nick Reilingh
    Sent: Thursday, April 21, 2016 10:08 AM
    To: Brian W. Grundstrom
    Subject: Re: [Tessitura Technical Forum] Users don't show up in Reset Operators Passwords

     

    Users don't have managers assigned to them. Users are assigned to groups, and then other users are assigned to manage those groups.

    I will offer that I made a version of a password reset utility that is shared via the bitbucket site (https://bitbucket.org/TN_WebShare/password-reset-utility) — email web_dev@tessituranetwork.com for access. One of the benefits of using a collaborative platform like Bitbucket is that everyone has visibility on the code and can submit enhancements or bugfixes to it. If you feel like switching over to that version, I'll be happy to help solve any problems if you encounter them.

    From: Gerald Boutot <bounce-geraldboutot3782@tessituranetwork.com>
    Sent: 4/21/2016 8:41:28 AM

    Thanks Beau. I did some investigating and found that many users that show up in the drop-down have no Manager assigned! And some that don't show up have a manager assigned.




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

       

Children
No Data