[Gusdev-gusdev] Re: DB user

[Jonathan C. <cra...@pc...>]

Hi Chetna-

Chetna Warade wrote:
> I understand that in gus2.0 there is a single schema/user "gusdev" which
> contains all tables but in 3.0 there are 5 users/schema (core,dots,tess
> ..) Who is this single user (read+write both) sitting in .gus.properties.

These are both additional users that aren't created by the schema install
scripts.  I didn't include them originally because I thought that different
sites might have different requirements in terms of granting update/read
privileges.  However, given that the install process requires an account
with read-only privileges on all of the 5 GUS schemas, I should probably
include this in the next release.  There are some details to be worked out,
however.  For generating the objects, you have 2 choices right now:

1. Create a new user and use the script $GUS_HOME/bin/grantPermissions.pl
    to grant it SELECT permissions on all 5 schemas.
2. Use a user with DBA privileges to create the objects, since such a user
    will be able to see all of the tables, views, etc.

> Also I need your help (syntax types - I think I will have to give grant
> permissions to this user explicitly) for creating such two users.
> Basically one user with read+write permissions on all users/schema's
> tables and one user with read only permissions on all the user/schema's
> tables.

Yes, if you'd like to go this route then you can use the grantPermissions.pl
script to grant the permissions.  Did you see my earlier e-mail where I was
talking about the usage of this script?  In any case, if you run it without
any arguments it should give you a usage summary, and you can also look at
the examples in create-db.sh (in the Oracle schema directory) to see how it
works.  Let me know if you have any questions; I'll document this more
thoroughly in the schema install documentation, which I hope to finish
tonight.

Jonathan


-- 
Jonathan Crabtree
Center for Bioinformatics, University of Pennsylvania
1406 Blockley Hall, 423 Guardian Drive Philadelphia, PA 19104-6021
215-573-3115