Schema Browser | Users tab | Scripts tab is only generating a list of Revokes and Grants, or it is completely empty or blank. It does not generate a CREATE_USER ... script
Example:
REVOKE REFERENCES, SELECT ON HR.COUNTRIES FROM OE;
REVOKE SELECT ON HR.DEPARTMENTS FROM OE;
REVOKE REFERENCES, SELECT ON HR.EMPLOYEES FROM OE;
GRANT REFERENCES, SELECT ON HR.COUNTRIES TO OE;
GRANT SELECT ON HR.DEPARTMENTS TO OE;
GRANT REFERENCES, SELECT ON HR.EMPLOYEES TO OE;
The "Grants on the user's objects for other user/roles" option is checked for User Script tab. This generates a script with any privileges granted to other users on this users objects.
1. Select Schema Browser | Users tab and select a user name.
2. On the right-hand side, select Script tab.
2. Select the first icon on Script tab tool bar: "'View/Edit script options'".
3. Select the User tab.
4. Uncheck "'Grants on the user's object for other user/roles" check box and hit OK.
If you have problems with Toad hanging because of the change in settings, please refer to SOL37674.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center