• Replies 6 replies
  • Subscribers 336 subscribers
  • Views 100 views
  • Users 0 members are here
Related

In T_METUSER where are the values for the Location dropdown in the Security Module pulled

Tom Brown (Past Member)
$organization

We want to add a new location to the Security module when we create new users.

 

In what table do we add a new location option?  This data ends up in T_METUSER.location.

 

--Tom

  • Former Member
    Former Member $organization

    Tr_location is the table that controls locations.

     

     -steve carlock

    Information Technology Manager

    The Granada

    jsc@granadasb.org

    (805) 899-3000x111 (office) - Note: New Office Number as of 2009-11-01

    (805) 899-3002 (fax)

    (562) 239-7075 (cell)

     

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Tom Brown
    Sent: Thursday, November 19, 2009 10:36 AM
    To: Steve Carlock
    Subject: [Tessitura Technical Forum] In T_METUSER where are the values for the Location dropdown in the Security Module pulled

     

    We want to add a new location to the Security module when we create new users.

     

    In what table do we add a new location option?  This data ends up in T_METUSER.location.

     

    --Tom




    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!

  • $organization in reply to Former Member

    I believe tr_locations is what control locations in tx_machine_location and tr_dept is what controls locations in the security module.

  • $organization

    Hi Tom, security module retrieves location from TR_DEPT table which ends up in T_METUSER.location.

     

    Mo

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Tom Brown
    Sent: Thursday, November 19, 2009 1:36 PM
    To: Mohiuddin Faruqe
    Subject: [Tessitura Technical Forum] In T_METUSER where are the values for the Location dropdown in the Security Module pulled

     

    We want to add a new location to the Security module when we create new users.

     

    In what table do we add a new location option?  This data ends up in T_METUSER.location.

     

    --Tom




    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!
  • Former Member
    Former Member $organization

    Yes, you are correct.  We’re not using locations in the security module which is why I was confused.  Sorry about that.

     

     -steve carlock

    Information Technology Manager

    The Granada

    jsc@granadasb.org

    (805) 899-3000x111 (office) - Note: New Office Number as of 2009-11-01

    (805) 899-3002 (fax)

    (562) 239-7075 (cell)

     

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Tanya Hoffmann
    Sent: Thursday, November 19, 2009 11:02 AM
    To: Steve Carlock
    Subject: Re: [Tessitura Technical Forum] RE: In T_METUSER where are the values for the Location dropdown in the Security Module pulled

     

    I believe tr_locations is what control locations in tx_machine_location and tr_dept is what controls locations in the security module.