Can a Schema Owner grant object privileges in a regular schema?

• A. True
• B. False
• C. Only for managed access schemas
• D. It depends on the object type

Answer: (B)

Object privileges live at the object level, not at the schema level. Each object (like a table or view) has its own owner, and only that owner—or a role granted with the GRANT OPTION on that specific object—can grant privileges on it. Being the owner of the schema does not automatically give you the right to grant privileges on every object inside that schema.

In a regular schema, you can grant schema-level rights (such as USAGE or CREATE) and you can set permissions for future objects in the schema, but you cannot grant existing object privileges for objects you don’t own. If you want privileges on future objects, you can use a statement like GRANT ... ON FUTURE TABLES IN SCHEMA to allow access when those objects are created, but that still depends on ownership or proper grant options on those future objects.

So the statement is false: a Schema Owner cannot grant object privileges on all objects inside a regular schema by virtue of owning the schema; object privileges require object-level ownership or explicit grants on each object.