Connect through access not working

Database
Enthusiast

Connect through access not working

Hi,

I had granted connect through access to the user as shown below,

GRANT CONNECT THROUGH trusted_user_name TO app_user_name WITH ROLE role_name ;
Row getting inserted into DBC.CONNECTRULES table even though user does not getting connect through access. When i tried to give the access to the user with single quotes as shown below in second record it's working fine.
TrustUserProxyUserProxyUserTypeGrantStatusWithoutRoleProxyRole1CreatorNameCreateTimeStamp
GPDW_USERK312840AG FDWT_INT_DX_VIEWS_ROLEFDW_ADM11/25/2016
GPDW_USER'K312840'AG FDWT_INT_DX_VIEWS_ROLEFDW_ADM11/25/2016

Can some one please let me know why it's not working in first case and as well working great in second case.

1 REPLY
Enthusiast

Re: Connect through access not working

Hi,

I had granted connect through access to the user as shown below,

GRANT CONNECT THROUGH trusted_user_name TO app_user_name WITH ROLE role_name ;
Row getting inserted into DBC.CONNECTRULES table even though user does not getting connect through access. When i tried to give the access to the user with single quotes as shown below in second record it's working fine.
TrustUserProxyUserProxyUserTypeGrantStatusWithoutRoleProxyRole1CreatorNameCreateTimeStamp
GPDW_USERK312840AG FDWT_INT_DX_VIEWS_ROLEFDW_ADM11/25/2016
GPDW_USER'K312840'AG FDWT_INT_DX_VIEWS_ROLEFDW_ADM11/25/2016

Can some one please let me know why it's not working in first case and as well working great in second case.