Hi gurus,
I need your assistance. I have created a custom screen and placed it in the title section of production elements. I can go to the screen in Tessitura however I am not able to add or delete any data. I have combed through the security setup but cannot seem to find the object that grants permissions to this area. Any ideas?
Many thanks!
Naomi
It may be that your procedure or custom table does not have permissions assigned. Do this in SQL Management Studio. Right click on the object and select Permissions. Then normally you give select rights to the impusers group.
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Naomi Williams Sent: Monday, July 19, 2010 10:12 AM To: Gloria Ormsby Subject: [Tessitura Technical Forum] Security for custom screen in production elements
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!
Hi Gloria,
I checked the table and it has select, insert, update and delete for the impuser group. Any other thoughts?
Did you check in the Security application where you assign security groups to the system tables?
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Naomi Williams Sent: Monday, July 19, 2010 10:47 AM To: Gloria Ormsby Subject: RE: [Tessitura Technical Forum] Security for custom screen in production elements
From: Gloria Ormsby <bounce-gloriaormsby5026@tessituranetwork.com> Sent: 7/19/2010 9:39:51 AM
It doesn't show in the security application because it is not a table they can access thru Tessitura like a TR table or an LTR table. I am completely confused as to why it is not allowing me to add data.
Do you have:
1. The update table column filled in on TR_CUSTOM_TAB?
2. A column in the column specifications named id_key
-Ryan
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Naomi Williams Sent: Monday, July 19, 2010 7:47 AM To: Ryan Creps Subject: RE: [Tessitura Technical Forum] Security for custom screen in production elements
Hi Ryan,
I have the correct table in the update table column in TR_Custom_Tab.
I have a column in my local table that is the primary key and named accordingly id_key.