In order for a user to create tables under a schema that is not their own, they must be granted the CREATE ANY TABLE privilege directly or via a role. Use that privilege with caution, though, since it really does mean ANY and once granted, the user may create tables under privileged schemas like SYSTEM.
Dig deeper on Oracle database security
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.