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.
Unknown said: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.
Not a great idea. If they repeatedly need to know something from a system table that the user in question (in Marketing?!) doesn't usually have access to, I'd set up a custom report that pulls only the minimum tables, columns, types, etc. that this person needs to see.