Announcement

Collapse
No announcement yet.

sys_context('gl_user_ctx','gl_user_gid') not returning user_id

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • sys_context('gl_user_ctx','gl_user_gid') not returning user_id

    Hi
    For what reason would the following statement in a new VPD profile created by me not return the user id

    sys_context('gl_user_ctx','gl_user_gid')

    I am getting the result for sys_context('gl_user_ctx','user_role_gid') but the not the one above.

    the 'gl_user_gid' statement is working in my servprov VPD but not in the new one I created. Does it require more setup?

    Thanks

  • #2
    Re: sys_context('gl_user_ctx','gl_user_gid') not returning user_id

    Hi

    You need set user vpd. Example:
    BEGIN
    glogowner.vpd.set_user('DBA.ADMIN');
    END;

    Comment

    Working...
    X