Toad World® Forums

Cannot revoke grants to another schema's objects from a role via SB

Howdy!

Subject about says it all. In 12.0.6.20b SB for Roles, I select the role on the LHS, then the Object Grants tab on the RHS. Select an object grant to revoke that’s in another schema (or the “Revoke all…” scissors icon) and Toad gets an “ORA-00942: table or view does not exist” error. A SQL grab shows that no owner is specified on the REVOKE statement:

Revoke SELECT on NOT_MY_TABLE from MY_ROLE

The “Revoke all…” also does kind of a seizure-inducing progress window popup on the 4400 revokes I attempted, but I don’t know if that’s because they all failed or not.

Thanks much!
Rich

Thanks Rich. I’ll take care of it.

I meant to post this in the beta forum, but I’m guessing it’s the same in the GA, so no one will ever know of my grievous error…

Thanks John!

Rich

I should also have added that altering the role (from the LHS) to revoke the grants works smoothly as expected, so there’s an easy workaround.

And if anyone’s seen my head lying around somewhere, its prompt return would be most appreciated. Thank you very mucho.

Rich

This is looking good in 12.6.0.31…

Thanks again John!

Rich

You’re welcome, Rich.