The following errors are observed in target event_log when SP_OCT_REPLICATE_GRANT is enabled and a SELECT on a table is granted to a user but the user does not exist on target. However, the Post does not stop due to this error:
sp_ctrl (alvsupl18:9111)> show log reverse
.
.
Error 2018-07-02 17:08:34.197031 11782 221996800 s:5 Poster: 15033 - Failed to execute SQL on table "SHA91"."TABLE1": ORA-01917: user or role 'SHA91A' does not exist (posting from o.ORA11GR2, queue alvsupl14, to o.ORA11GR2) [module opo]
Notice 2018-07-02 17:08:34.196972 11782 221996800 s:5 Poster: Oracle error: ORA-01917: user or role 'SHA91A' does not exist rowid:N/A (posting from o.ORA11GR2, queue alvsupl14, to o.ORA11GR2) [module opo]
Notice 2018-07-02 17:08:34.196660 11782 221996800 s:5 Poster: ORA-01917: user or role 'SHA91A' does not exist (posting from o.ORA11GR2, queue alvsupl14, to o.ORA11GR2) [module osp]
Info 2018-07-02 17:05:23.824231 11782 960821088 Poster launched, pid = 11782 (posting from o.ORA11GR2, queue alvsupl14, to o.ORA11GR2)
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