Toad World® Forums

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

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;

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

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

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

We are currently targeting late Q2 2012

We are currently targeting late Q2 2012