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.
  • SELECTIN allows the user to execute select query on tables within the schema
  • UPDATEIN allows the user to update a table within the schema
  • INSERTIN allows the user to insert data into a table within the schema
  • DELETEIN allows the user to delete rows from tables within the schema
  • EXECUTEIN allows the user to execute user-defined functions, methods, procedures, packages, or modules defined in the schema.

The owner of the schema has CREATEIN, ALTERIN, DROPIN, and SCHEMADM privileges. The owner also gets the privilege to grant CREATEIN, ALTERIN, and DROPIN to others. The objects that are manipulated within the schema object include: tables, views, indexes, packages, data types, functions, triggers, procedures, and aliases.