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.
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.