so what exactly authirzation grants you ? allowing the owner of the schema change properties of the tables ? allowing the owner of the schema grant permissions on the tables in that schema ?
I tried to query with my user (mariel) a table in a schema that is owned by my user but I couldnt query that table because of lack of permissions.
It suppose to mean that all objects that will be created in the sqlite_foreign_Schema db will be owned by the user mariel.
Authorization does not “mean that”: ownership of a schema has no bearing on ownership of contained objects. Your questions boil down to this misunderstanding.