Dear colleagues, For the last few hours I tried to implement $subj, to no avail. I tried to use create rule (no grant statement allowed), create function (syntax error on $1), etc. I have roles mng and rdr, and want that any newly created class (table, view, seq, index) will be available for wrining to mng and for queriyng to rdr. Any hints? Thanks in advance. Sincerely, D.Marck [DM5020, MCK-RIPE, DM3-RIPN] [ FreeBSD committer: marck@xxxxxxxxxxx ] ------------------------------------------------------------------------ *** Dmitry Morozovsky --- D.Marck --- Wild Woozle --- marck@xxxxxxxx *** ------------------------------------------------------------------------ ---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate