Schema privileges

Schema privileges are in the object privilege category.

Object privileges are shown in Figure 1.

Figure 1. Object privileges

Schema privileges involve actions on schemas in a database. A user, group, role, or PUBLIC can be granted any of the following privileges:

  • CREATEIN allows the user to create objects within the schema.
  • ALTERIN allows the user to alter objects within the schema.
  • DROPIN allows the user to drop objects from within the schema.

The owner of the schema has all of these privileges and the ability to grant them to others. The objects that are manipulated within the schema object include: tables, views, indexes, packages, data types, functions, triggers, procedures, and aliases.