Hi all,
We have issue
ORA-01720: grant option does not exist for 'creator.collateralevaluation'.
CREATE VIEW zoo.v2947collateralevaluation
AS SELECT * FROM creator.collateralevaluation
GRANT select ON zoo.v2947collateralevaluation TO USER1234;
we tried also
GRANT SELECT ON creator.collateralevaluation TO USER1234 WITH GRANT OPTION
but it fails...
Error at line 1
ORA-01031: insufficient privileges
Please help me find solution...
SELECT * FROM V$VERSION
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
PL/SQL Release 11.2.0.4.0 - Production
CORE 11.2.0.4.0 Production
TNS for 64-bit Windows: Version 11.2.0.4.0 - Production
NLSRTL Version 11.2.0.4.0 - Production
5 rows selected.