There is a problem in granting roles. After double clicking a table on the object palette window, it generates the DDL, but the GRANT statement is wrong about ROLE. TOAD generates the GRANT as follows:
GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE x.y TO USER ROLE_USR;
But "ROLE_USR" is a ROLE not USER
The right statement should be
GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE x.y TO ROLE ROLE_USR;
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center