Hi all,
I really hate this new buggy site..attempting to write this post for the 3rd time.
I'm trying to use user groups to restrict access to an app. The problem is that in the users section & the user group section my username is G525PHB. When I login to our homepage the &APP_USER. shows g525phb.
This has lead me to find some bad coding of Oracle in that they don't make CURRENT_USER_IN_GROUP case insenstive by making the username UPPER...especially because (as far as I can see) you can't set a username to lowercase through APEX~ I tried updating my username in the management section to 'g525phb' but it went straight back to uppercase.
Is there any way around this? Ideally without having to use "GET_GROUPS_USER_BELONGS_TO" since I crashed our APEX prod earlier by attempting to split the string without an end to my loop clause :-x then I found CURRENT_USER_IN_GROUP but then the case issue was found
Any ideas around it? I'm using apex 4.0.2.00.07
Edit: why is there no "USER_IN_GROUP" function? =(
Dird