Nathan Jahnke <njahnke@xxxxxxxxx> writes: > So the role "sample" owns the database "sample" and has default > privileges on the table "users" in that database. From the manual: > "There is no need to grant privileges to the owner of an object > (usually the user that created it), as the owner has all privileges by > default." Owning the database has little or nothing to do with owning the objects within it. You have not shown us who owns the table users, but I bet it's not "sample". regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general