REMOVE_GU_TRUST

Remove a GU trust relationship.

The execution of new SQL GRANT statements is disallowed if a GU trust relationship is removed. Existing grants are not affected from a removing a GU trust relationship.

This procedure deletes a row from table REP_GU_TRUST.

Parameter Name	Required	DefaultValue	Values	Description
p_grantor	yes			The username of a GU-user that is allowed to provide object grants. The combination of p_grantor and p_grantee must exist in a row in table REP_GU_TRUST.
p_grantee	yes			The username of a GU-user that is allowed to receive object grants. The combination of p_grantor and p_grantee must exist in a row in table REP_GU_TRUST.

Example

Remove the GU trust relationship between users ‘GU1’ and ‘GU2’:

EXEC p_rep_admin.remove_gu_trust
    ( 'GU1'
    , 'GU2' );