• Replies 8 replies
  • Subscribers 248 subscribers
  • Views 95 views
  • Users 0 members are here
Related

Cannot inactivate email b/c used by login

Kanani Reichlin
$organization

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

  • $organization

    Weird indeed. But we had a situation like this a few months ago. It is possible for your DBA to transfer the email and login to the correct account using SQL.

    Or if you'd prefer to do it from the front end you can inactive the login then inactive the email address on the wrong account. Then simply add the email address and create a new login on the correct account.

  • $organization in reply to Beth Hawryluk

    If I can do it from the front end that would be best.  Where do you inactivate the login?

     

    p.s. I'm now essentially the DBA and learning SQL so if you know which table this would be under that would be helpful, but like I said front end is preferred.

     

    Thanks for you reply!

  • $organization in reply to Kanani Reichlin

    I'm also recently a DBA who is learning SQL. So I share your pain! :)

    The table that holds login info is T_CUST_LOGIN. I wouldn't recommend making changes here unless you are totally comfortable doing it (or unless you are able to test, test, test before doing it live!).

    I'm assuming you are on V11 so let me know if you are not. From the front end, load the constituent record and go to the Contact Details tab. Under the Logins button you should be able to edit the login you want to inactivate. You have to uncheck the primary box first and then check the inactivate box.

    Hope that helps!

  • $organization

    If you’re on Version 11 , under Contact Details , RB Logins – you are able to delete the login email address from there …

     

    Sabina

     

    From: Tessitura Web Forum [mailto:forums-tessitura-web@tessituranetwork.com] On Behalf Of Kanani Knudson
    Sent: Friday, December 14, 2012 11:29 AM
    To: Sabina Spilkin
    Subject: Re: [Tessitura Web Forum] Cannot inactivate email b/c used by login

     

    If I can do it from the front end that would be best.  Where do you inactivate the login?

     

    p.s. I'm now essentially the DBA and learning SQL so if you know which table this would be under that would be helpful, but like I said front end is preferred.

     

    Thanks for you reply!

    From: Beth Hawryluk <bounce-bethhawryluk7830@tessituranetwork.com>
    Sent: 12/14/2012 1:04:48 PM

    Weird indeed. But we had a situation like this a few months ago. It is possible for your DBA to transfer the email and login to the correct account using SQL.

    Or if you'd prefer to do it from the front end you can inactive the login then inactive the email address on the wrong account. Then simply add the email address and create a new login on the correct account.




    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!

  • $organization

    I’m on version 10.  So I suppose that functionality isn’t on version 10?

     

    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 Sabina Spilkin
    Sent: Friday, December 14, 2012 11:56 AM
    To: Kanani Knudson
    Subject: RE: [Tessitura Web Forum] Cannot inactivate email b/c used by login

     

    If you’re on Version 11 , under Contact Details , RB Logins – you are able to delete the login email address from there …

     

    Sabina

     

    From: Tessitura Web Forum [mailto:forums-tessitura-web@tessituranetwork.com] On Behalf Of Kanani Knudson
    Sent: Friday, December 14, 2012 11:29 AM
    To: Sabina Spilkin
    Subject: Re: [Tessitura Web Forum] Cannot inactivate email b/c used by login

     

    If I can do it from the front end that would be best.  Where do you inactivate the login?

     

    p.s. I'm now essentially the DBA and learning SQL so if you know which table this would be under that would be helpful, but like I said front end is preferred.

     

    Thanks for you reply!

    From: Beth Hawryluk <bounce-bethhawryluk7830@tessituranetwork.com>
    Sent: 12/14/2012 1:04:48 PM

    Weird indeed. But we had a situation like this a few months ago. It is possible for your DBA to transfer the email and login to the correct account using SQL.

    Or if you'd prefer to do it from the front end you can inactive the login then inactive the email address on the wrong account. Then simply add the email address and create a new login on the correct account.




    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!




    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!

  • $organization in reply to Kanani Reichlin

    It is on version 10 but the tabs are different. I believe the V10 tab was called Addresses and there were email and login buttons within that tab.

    The process should be the same though as far as I know.

  • $organization
    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
  • $organization

    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!