By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,586 Members | 2,347 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,586 IT Pros & Developers. It's quick & easy.

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

P: n/a
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
Share this Question
Share on Google+
3 Replies


P: n/a
use trigger on create.
Sep 4 '07 #2

P: n/a
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

P: n/a
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.