|
From: Jonathan C. <cra...@pc...> - 2003-02-24 21:51:29
|
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
|