Instead of "UNLIMITED TABLESPACE", Can I Grant Sites db user "QUOTA UNLIMITED" on the Tablespaces Used by Sites? (Doc ID 1993604.1)

Last updated on JULY 07, 2017

Applies to:

Oracle WebCenter Sites - Version 11.1.1.8.0 and later
Information in this document applies to any platform.

Goal

WCSites documentation states that we need to grant “UNLIMITED TABLESPACE” privilege to the WCSites user on the database.

However, if "UNLIMITED TABLESPACE" is against our policy, can we grant “QUOTA UNLIMITED” only to the tablespace used by WCSites instead?

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms