Ask the Expert

Setting permissions to create tables under another user's schema

How can I set permissions on specific users, so that one can create tables under another user's schema.

    Requires Free Membership to View

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.

This was first published in June 2004

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.