[rt-users] urgent: disable search for new watchers

[Ken Crocker]

Violetta,

    In Oracle (and I assume other DB's) a "View" is a way to allow users 
to "See" specific data on a database without allowing them to "See it 
all" nor to change the data. It is "Realtime". By using SQL, I create a 
VIEW to RT Data. Meaning, a "psuedo-table".LEt's say I have 3 fields 
from table 1, 2 fields from table 2, 8 fields from table 3 that I want 
some users to see. I do NOT want them to see "other" information, nor do 
I want these users to be able to modify any of the table data. So, I 
create a "view" of these fields from the various tables and it is 
accessed much like one would access a table in a DataBase. Hence the 
term "View". Your DBA could tell you if your environment has such a 
thing. IF so, they can tell you how to create it. It is ALWAYS 
accessible (via userid and password) as long as the DataBase is up and 
the dat is NOT loaded, it is "filetered" so to speak. Think of it as a 
WINDOW to the DataBase. You can't see it all, you can only see what is 
specified. Hope this helps.

Kenn
LBNL

On 6/22/2009 2:03 AM, Violetta J. Wawryk wrote:
> Hi Kenn,
>
> I might not understand your concept. What does such a view look like? 
> Our customner wants to check anytime which tickets are new, open and 
> resolved which I thought is the quickest via browsing the RT. Of 
> course I am happy to get more infomation about your views, but to be 
> honest, in my opinion RT should offer me that requirement.
>
> Regards
> Violetta
>
> Ken Crocker schrieb:
>> Violetta,
>>
>>    I just thought of an idea, but it would require a bit of work. Why 
>> not try create some views that have only the info you want these user 
>> to see and then remove them from RT. They can still get to the RT 
>> info thru the views, which SHOULD suffice, since they are gonna be 
>> creating searchs and reports. I'm not sure how your infrastructure is 
>> where you work, but we have many users that do NOT access RT, but 
>> create their own SQL reports all the time thru the views. We're on 
>> Orcale, but I'm sure the same concept is doable with other DB's. I 
>> even have some SQL that I use to create the views. I'd be MORE than 
>> happy to send it to you and you can modify the info as per your 
>> needs. They even have comments, which you can't get to in RT Query. 
>> Just a thought.
>>
>> Kenn
>> LBNL