Forum Discussion

Normd's avatar
Normd
Occasional Contributor
14 years ago

What are the exact permisions required for codecollaborator's Oracle account.

I hope someone can help me out here as support is being very ellusive in their response and the docs only state full access.   What are the exact grants required for this Oracle account? I've gr...
ebrown_1's avatar
ebrown_1
Icon for Alumni rankAlumni
14 years ago
Perhaps you can help us answer this definitively, since we don't have an Oracle DBA in house.  We do know that in most Oracle configurations, you can fulfill all requirements by running CREATE USER COLLAB ...  And then using COLLAB for both the username and schema for Code Collaborator.  Are the granted privileges the same as running GRANT ALL ON schema.* TO COLLAB?  And are there privileges given by these that you are concerned about?