Updated on 2024-12-18 GMT+08:00

Schema Object Design

Suggestion 2.7: Avoiding the Creation of Objects Under Other Users' Private Schemas

A private schema refers to a schema with the same name as the user when the user is created. This schema is only accessible to the user.

Impact of rule violation:

  • When you create an object under someone else's private schema, the permissions for that object are determined by the schema owner.

Solution:

  • Create objects under your own private schema to have full control over the object permissions.