You can create a new template database with this change applied if you want to. If you want to delegate every right explicitly, revoke all from public, or simply drop the public schema. Daniel has already explained how to revoke that right if desired. It doesn't matter that you haven't granted the user any rights other than granting CONNECT on the database, because the public schema permits all users to create tables in it by default. The users' rights on the database are irrelevant at this point, as the user isn't trying to do anything to the database object its self, only a schema within it. Everyone has rights to public by default, so the creation is allowed. If you do not specify the schema to create an object like a table in, the database engine uses the search_path, and by default the public schema is first on the search_path so the table is created there. USAGE: List objects in the schema and access them if their permissions permit.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |