Our company currently uses Commercial Media to handle our website programming. In the course of those operations, we are sometimes asked by them to provide information that only one such as I (DBA) would have access to; information within certain tables such as facil_no in T_FACILITY, Problem is, they often only ask someone other than me, such as a contact in Marketing. The answer to this so far, is to have me make those tables available to this Marketing contact so answers can be made available to CM whenever called for.
My question is this: if such things happen at other organizations, how are they handled? I could make a report in Reporting Services that pulls that data from whatever table is looked for, but that's about 21 tables and I don't want to have to do that. Unfortunately, I am not versed in dynamic SQL which might make this task a bit easier - or at least more efficient, coding-wise. I know that it's possible to make tables available in System Tables in Tessitura, but I'm not sure that's a good idea either.
Any suggestions?
As always, thank you in advance, Tessiturians.
BONUS TRIVIA MORSEL: On this day, October 13th, in 1792, the cornerstone of the White House was laid.
You can give users view only access to system tables. See the system table section in the Security Administration document for details.
There are a few IDs that your web integrator may want that do require querying the database. Facility ID is one of those. Most of them, though, can be found in a system table or on the screen where the item is set up (such as MOS and performances).
Kevin Sheehan
Documentation & Learning Resources Specialist
Tessitura Network
1 888 643 5778 ext 329 Office
ksheehan@tessituranetwork.com