Re: [SQL] GRANT ON all tables

2004-08-27 Thread Bruno Wolff III
On Fri, Aug 27, 2004 at 15:30:32 -, Nosyman <[EMAIL PROTECTED]> wrote: > 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 privil

[SQL] GRANT ON all tables

2004-08-27 Thread Nosyman
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, DE