AsI can give youfull permissionto a user ina database.For everything youhavethat databaseandthe objectsto be created inthe future. This meansyou can accessall the schemes,all tables,views, functions,etc. If in the futureyou createa new viewdoes nothave to do aspecificGRANTtothat usersince the useris the"owner" ofthe database.
Try sayingthe userissuper-user andrestrict accessonly to thedatabase frompg_hba.But beingsuper-user canfor exampledeleteanother databasethat is not theirs.