>>>>> "rajan" == rajan <vgmon...@gmail.com> writes:
rajan> --with the student user have no privilege how ALTER DEFAULT PRIVILEGES rajan> works???? rajan> *learning=> ALTER DEFAULT PRIVILEGES IN SCHEMA additional GRANT INSERT ON rajan> TABLES TO student; This ALTER only affects the default privileges for tables created by the role "student" (because they're the ones executing the ALTER), it does not affect default privileges for tables created by anybody else. -- Andrew (irc:RhodiumToad)