How can i revoke tablespace privileges(from a userid) in DB2 V6.1? Because V6 does not support this. Since this is production system, i can not drop and recreate tablespaces. Is there any way to do it??

Prakash,


In DB2 UDB V6.x , tablespace privileges can not granted.

but in V7

following command can be used to control tablespace privileges


REVOKE USE OF TABLESPACE tablespace-name FROM USER


Let me know , if any questions


Thank You

Lekharaju Ennam

Thanks.

Yes. We can not grant tablespace privileges seperately(in V6).
But when we create a database, tablespace(userspace1) USE privilege will be granted to PUBLIC(by default). How can we revoke this??