Granting DML privileges on all the tables of a schema to a user

Rahul B

Hi,

I want to grant only the connect, select, insert, update privileges on
all the tables of a schema to a particular user/group
Initially, i had revoked all the privileges from public.

It seems that the privileges Select, Insert, Update can be given only
on a table level and not on the schema level.
I can iterate and get the script for the select privileges for all the
tables and execute it.

However, if the admin user creates the table in that schema, i will
need to grant the select, insert, update privs for newly created table
to the user again.

Is there some other way to realize that(like giving select, insert,
update privs on all the tables of that schema)

Rahul

Sep 3 '07 #1

Ekta

use trigger on create.

Sep 4 '07 #2

Knut Stolze

Ekta wrote:

use trigger on create.

There are no CREATE-triggers in DB2 (yet).

--
Knut Stolze
DB2 z/OS Utilities Development
IBM Germany

Sep 4 '07 #3

Rahul B

On Sep 4, 1:43 pm, Knut Stolze <sto...@de.ibm.comwrote:

Ekta wrote:

use trigger on create.

There are no CREATE-triggers in DB2 (yet).

--
Knut Stolze
DB2 z/OS Utilities Development
IBM Germany

Hi,

What should be done in this case(no create triggers in DB2 as yet)

Rahul

Sep 4 '07 #4