Creating Versions erroring out in Oracle Spatial based ArcSDE

[SriramVenkatasubramaniam]

Hello ArcGurus,
    We are piloting with an Oracle Spatial based ArcSDE Geodatabase. In addition to the default version, i was able to create only 1 version on top of default version . When i create more versions, i get an error "The version name already exists" .

But i have made sure after looking at SDE.versions that  i did not use  already existing version names. What could be the problem here. Is this a bug on ArcSDE ?

Thanks
Sriram

[SriramVenkatasubramaniam]

Solved the issue ourself. The issue was with grant permissions to the schema which was used for editing. This user did not have all the required permission such as CREATE ANY.
Our DBA had revoked certain CREATE ANY privileges and that was causing the issue above.

Hope this will be helpful for somebody else.

-Thanks
Sriram

[VinceAngelo]

Your DBA was wise to revoke CREATE ANY privileges.  There aren't many valid uses for
CREATE ANY, and none that involve geodatabases.  You really need to roll back to start
on the security model in your Oracle instance and implement best practices.

- V