On logical standby you have to switch off data guard at least on session level to make modifications on objects which are maintained by data guard.<\/p>\n
This is done by command<\/p>\n
Dataguard can be reenabled for this session by issuing<\/p>\n For executing these commands “alter database” privilege is at least needed, which is often not liked by IT security staff.<\/p>\n Command “alter session disable guard” is also used in login triggers of logical standby databases for power users who have to do modifications in objects which are maintained by data guard. Problem is that no view can be queried to get data guard status of the session.<\/p>\n Workaround is to put result of login trigger into a log table which can be queried by the user.<\/p>\n","protected":false},"excerpt":{"rendered":" On logical standby you have to switch off data guard at least on session level to make modifications on objects which are maintained by data guard. This is done by command alter session disable guard; Dataguard can be reenabled for this session by issuing alter session enable guard; For executing these commands “alter database” privilege […]<\/p>\n","protected":false},"author":27,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[198,59],"tags":[1408,1409,1410,1411,1412],"type_dbi":[],"class_list":["post-11496","post","type-post","status-publish","format-standard","hentry","category-database-management","category-oracle","tag-alter-session","tag-disable-guard","tag-enable","tag-logical-standby","tag-view"],"acf":[],"yoast_head":"\n
\nalter session disable guard;
\n<\/code><\/p>\n
\nalter session enable guard;
\n<\/code><\/p>\n