Hello ppls,

We are using DB2 V8.2 for ERP(peoplesoft application)

Developers most of the time drop and recreate the tables via application side (not from DB side)

As everyone know, dropping the table removes all the privileges pertaining to that table.

The moment that table got dropped, i would like to grant select & update privileges to 3 - 4 users. Also i would like to automate this process.

Is there anyway we can do that? Trigger is out of scope, as there is no option of 'after create/drop'.

Will be great if anyone can shed some lights over here. Thanks.

If the programmers are dropping and recreating tables via the application, then they should also recreate the privileges.

Andy

No Andy,

(Peoplesoft) tool gives you the possibility of dropping and recreating only.

It is not having the flexibility of adding a extra DDL statement to it.

Unless you can have a window from when the table gets created to when the privileges get granted, you have a problem. The best I can offer is to set up a monitoring script on the server that detects a new table and then grants the privileges. Then schedule the script to run every few minutes (whatever your window is).

Andy

My window is very small. As mentioned by you, i will have scripts scheduled as the last option.

Thanks andy for your inputs.