Cannot inactivate email b/c used by login

Hi Friends,

We had an odd occurrence.  A patron contacted our box office saying when she logs in to our website with her email address it says her name is Eileen Wilcox, when really her name is Linda Corcorran.  I went into Eileen Wilcox's account, and sure enough Linda's email address is in her record and it can not be inactivated because it is used by a login.

I don't know how this happened, but would like to fix it.  After some researching, I think this will be a SQL task, but wondering if anyone can tell me what needs to be done.

 

Thanks,

Kanani

Parents
  • That worked!  At least to delete the login from the wrong account.  Now I just need to create the new login on the correct account and we should be good.

     

    Thanks y’all

     

    Kanani Knudson| Sales and Database Coordinator | (206) 443-0807 x1206| Ticket Office: (206) 441-3322
    Seattle Children's Theatre |
    www.sct.org| 201 Thomas St. Seattle WA, 98109

     

    From: Tessitura Web Forum [mailto:forums-tessitura-web@tessituranetwork.com] On Behalf Of Beth Gilliland
    Sent: Friday, December 14, 2012 2:42 PM
    To: Kanani Knudson
    Subject: Re: [Tessitura Web Forum] Cannot inactivate email b/c used by login

     

    Also make sure you have rights via the security module that allow you (your usergroup) to edit and delete logins (Const Login RB object, I believe). This thread today made me realize that our users only had view rights, and you have to explicitly allow edit and delete permissions to do what your asking. A true admin login should implicitly allow you to do all those things. All other users need explicit permissions to do so.

     

    Beth




    You were sent this email automatically because you subscribed to the Tessitura Web forum. You may reply to this message to post to the Web 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
  • That worked!  At least to delete the login from the wrong account.  Now I just need to create the new login on the correct account and we should be good.

     

    Thanks y’all

     

    Kanani Knudson| Sales and Database Coordinator | (206) 443-0807 x1206| Ticket Office: (206) 441-3322
    Seattle Children's Theatre |
    www.sct.org| 201 Thomas St. Seattle WA, 98109

     

    From: Tessitura Web Forum [mailto:forums-tessitura-web@tessituranetwork.com] On Behalf Of Beth Gilliland
    Sent: Friday, December 14, 2012 2:42 PM
    To: Kanani Knudson
    Subject: Re: [Tessitura Web Forum] Cannot inactivate email b/c used by login

     

    Also make sure you have rights via the security module that allow you (your usergroup) to edit and delete logins (Const Login RB object, I believe). This thread today made me realize that our users only had view rights, and you have to explicitly allow edit and delete permissions to do what your asking. A true admin login should implicitly allow you to do all those things. All other users need explicit permissions to do so.

     

    Beth




    You were sent this email automatically because you subscribed to the Tessitura Web forum. You may reply to this message to post to the Web 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