467,202 Members | 1,022 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,202 developers. It's quick & easy.

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

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
  • viewed: 4414
Share:
3 Replies
use trigger on create.
Sep 4 '07 #2
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
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

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by LazyAnt | last post: by
7 posts views Thread by datapro01@yahoo.com | last post: by
1 post views Thread by zeus@ix.netcom.com | last post: by
14 posts views Thread by Bob Stearns | last post: by
5 posts views Thread by Rahul B | last post: by
6 posts views Thread by Frank Swarbrick | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.