Schema-based permissions
Schema-based permissions are determined by the owner of the schema:
-
By default, all users have CREATE and USAGE permissions on the PUBLIC schema of a database. To disallow users from creating objects in the PUBLIC schema of a database, use the REVOKE command to remove that permission.
-
Unless they are granted the USAGE permission by the object owner, users cannot access any objects in schemas they do not own.
-
If users have been granted the CREATE permission to a schema that was created by another user, those users can create objects in that schema.
