[Gusdev-rad-issues] Re: Questions (MIKE please note)

[Elisabetta M. <man...@pc...>]

Hi Urska,
thanks for your interest in RAD.
RAD is part of GUS which here is installed on Linux. But our dba Mike 
Saffitz, here cc-ed, is the best person to respond to your questions 
regarding installation and Oracle.
In GUS we have a system of attaching to each individual row in each table 
information on user, group, project and read/write permissions, so one 
could have fine control up to row-by-row if desired.
In our instance we typically apply control on a larger level, i.e. at the 
study level (RAD3.Study) and we have a web interface that queries RADs and 
shows publicly only those studies whose other_read is set to 1 (and 
everything relative to that study, from hybs info to final quantified 
results is visible) and which shows the private studies only upon logging 
in. Again, this is how we use our instance of the system, but the system 
is flexible enough to allow control as fine as desired.
Elisabetta
P.S. We have a sourcefourge mailing list for RAD, which I have cc-ed in my 
reply. You might want to subscribe to it and it would be helpful if for 
any RAD related question you could email to that list.

---

On Thu, 14 Oct 2004, Urska Cvek wrote:

> Hello,
>
> I have discovered your RAD database of microarray and non-microarray experiments. I would like to use it, but I have been trying to figure out some answers as to how exactly this works:
>
> - RAD is implemented on top of GUS - where is GUS installed and where is RAD installed? Are they running of a single Linux/UNIX server, or are they installed on a Windows server?
>
> - I need to provide different levels of user access, for example, access to only public data to certain users, and access to all data for other users (like the administrators or investigators). Do you have that implemented as well?
>
> - My last question is wrt Oracle - I visited the Oracle web page and as it looks like I can download and install Oracle 9i for free. Am I correct (I am at an educational institution and this would be a non-commercial database) or do I have to have a different version of Oracle that is not free?
>
> Thank you,
>
> Urska Cvek
> Assistant Professor
> LSUS