readonly tablespace

[Maryan]

Hi everybody,

i have created a tablespace, now i want to change it to readonly. Is it possible to do that in db2 v9. I couldn't find anything about that.

Is it possible to create a readonly tablespace in db2 at all?

Thanks in advance.

Best Regards,
Maryan

[kazam]

Hi,

We cannot make tablespaces readonly in DB2

Thanks,
Madhavi

Hi everybody,

i have created a tablespace, now i want to change it to readonly. Is it possible to do that in db2 v9. I couldn't find anything about that.

Is it possible to create a readonly tablespace in db2 at all?

Thanks in advance.

Best Regards,
Maryan

[Parnamwulan]

Hello,

It depends .... if you would like the table to be read-only for some user, you can create a group with only SELECT priviledges (NO DELETE, DROP or UPDATE or INSERT - just SELECT ONLY)

then, if you will add the user to that group he will not be able to modify anything anywhere ...

or you can create a view for him with select only priviledge .... there is no possibility to restrict the editing of the table for all users ...

or you can in fact setup the trigger or stored procedure and you can have the same values in another table. Then you can trigger the update action on the table with its copy as source after each insert on the destination :)

CREATE TRIGGER name
AFTER INSERT on dastination.table
FOR EACH ROW
triggered action

... the same for update, drop, delete etc.