Inherited connection privileges

For Netezza systems that support multiple schemas in a database, a user who is granted access to a database automatically inherits access to the default schema of that database.

There is an exception on systems where the enable_user_schema setting is TRUE. In that case, the user always connects to a schema that matches their user name, not the database default schema.

If you change the default schema for a database, the user automatically inherits access to the new default schema and loses access to the previous default. If a user requires access to the previous default schema, that user must be explicitly granted access to that schema.