• Created by Unknown User (karen), last modified on Jan 25, 2008

Steps to be taken to set up Oracle Roles for accessing GLAST databases

1. Request Oracle DBA to create roles in each of the GLAST Oracle instances

2. Grant privileges to the roles on each GLAST instance for access to the individual databases.

3. Request DBA to create oracle accounts that will use the roles in each GLAST instance

4. Grant roles to the oracle accounts

5. Modify existing code to explicitly state owner account of the table(s) being queried

  • No labels

1 Comment

  1. Tony Johnson

    Hi Karen, can we figure out how to set the "default schema" when accessing oracle tables via a role account so we don't have to change all the code to explicitly state the schema?