Hi there, I need to know how can I give privileges to all the tables in a database. For example, I have one database named "test" .This database contains about 30 tables. I want to grant SELECT and DELETE privileges to the 'test_user' by typing GRANT .... just once (something like GRANT SELECT, DELETE ON all_tables TO test_user). It is possible? I search PostgreSQL docs and I can't find out...
Thanks Nosy _________________________________________________________________ Message sent using ITCNet free webmailer (http://www.easymail.ro) ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
