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

[surender]

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

[Igor]

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;