In Oracle SQL authorization, which privilege allows a user to create a table…

Oracle SQL privilege scope works on two levels: an ordinary privilege (for example, CREATE TABLE) applies only within the grantee's own schema, while the same action prefixed with ANY (for example, CREATE ANY TABLE) extends that action to every schema in the database. Predefined roles such as RESOURCE and DBA are administrative bundles of many such privileges rather than a single named privilege.

The question asks for the one privilege that specifically authorizes creating objects (tables) inside another user's schema. That is CREATE ANY TABLE — its ANY qualifier is exactly what extends table-creation rights beyond the grantee's own schema into any schema in the database.

• ALTER SYSTEM controls instance-wide configuration parameters; it is unrelated to schema object creation.

• RESOURCE is a predefined role granting ordinary object-creation privileges (CREATE TABLE, CREATE PROCEDURE, CREATE SEQUENCE, and similar) that apply only to the grantee's own schema — it carries no ANY-schema scope.

• DBA is a predefined role bundling a very large set of system privileges, including several ANY-scoped ones, for full administrative control; it is a broad role rather than the single targeted privilege.

Oracle's privilege documentation uses the ANY qualifier precisely to denote "in any schema" scope, which is why CREATE ANY TABLE — and not RESOURCE or DBA — is the privilege that fits this question.