Generate wrong script on view privilege. (revoke all privileges)

Toad for IBM DB2
1

When trying to revoke privileges on view from user using ‘revoke all privileges’ interface, Toad makes syntax error like below.

REVOKE SELECT ON VIEW SYSCAT.TABLES FROM USER U1;

It must be
=> REVOKE SELECT ON TABLE SYSCAT.TABLES FROM USER U1;
or REVOKE SELECT ON SYSCAT.TABLES FROM USER U1;

2

Hi Vajra,
Thanks for your feedback.
I have identified that this is known and already fixed issue (CR93422).
Fix will be in the next 5.1 release and can be reviewed in the nearest beta.
Generated script will be in the following format:
REVOKE SELECT ON “DB2ADMIN”.“VIEWTABA” FROM USER “ADMINISTRATOR”;
Vlas

3

Hi Vajra,
Thanks for your feedback.
I have identified that this is known and already fixed issue (CR93422).
Fix will be in the next 5.1 release and can be reviewed in the nearest beta.
Generated script will be in the following format:
REVOKE SELECT ON “DB2ADMIN”.“VIEWTABA” FROM USER “ADMINISTRATOR”;
Vlas

4

When is Toad for DB2 v5.1 scheduled to be released?

5

We are currently targeting late Q2 2012

6

We are currently targeting late Q2 2012