tomaz108
asked on
ORA-01720: grant option does not exist for 'KL.AB_KDS'
i have 3 schemas: CC, DD and KL. View XLEE is stored in schema DD. when i'm trying to
grant select on XLEE to CC; the following error is reported: ORA-01720: grant option does not exist for 'KL.AB_KDS'. what should i do? i already granted select on 'KL.AB_KDS' to CC.
grant select on XLEE to CC; the following error is reported: ORA-01720: grant option does not exist for 'KL.AB_KDS'. what should i do? i already granted select on 'KL.AB_KDS' to CC.
ASKER
// *Action: Obtain the grant option on all underlying objects of the view.
i already done that, but i still getting error: ORA-01720: grant option does not exist for 'KL.AB_KDS'
i already done that, but i still getting error: ORA-01720: grant option does not exist for 'KL.AB_KDS'
ASKER
KL.AB_KDS is table not view
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
you should grant "select" with grant options:
like this:
grant select on KL.AB_KDS to <user_name> with grant option;
like this:
grant select on KL.AB_KDS to <user_name> with grant option;
// *Cause: A grant was being performed on a view and the grant option was
// not present for an underlying object.
// *Action: Obtain the grant option on all underlying objects of the view.