By submitting your email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
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.