Hi Toadworld,
1)Logged in as SYS.
2)Click on any USER under USERS
3) Go to Script Tab
I used to generate user script but not any more, I see the following now.
I might have changed Toad Default settings. Any help ?
SET DEFINE OFF;
Prompt Revoke privileges on XXSCHEMA’s Objects
REVOKE DELETE, INSERT, REFERENCES, SELECT, UPDATE ON XXSCHEMA.AUDIT_MISSING_CLASS_STG FROM BACKUP
/
Thanks
Katukko