Yes - just select whichever solution meets your needs. There is no cost difference from Claromentis - although MSSQL and Oracle are commercial products and you need to be able to deploy these solutions for our system to run.
We work using individual permissions, groups and sub groups, roles, and extranet areas supplementary - can a user be a member of multiple groups? - Absolutely.