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;
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center