Please change your user handle from "user580230" to something meaningful. Refer : Video tutorial how to change nickname available
I cannot seem to find much information on how to set up ORDS with AD SSO on tomcat, so not sure how people have done it out there...
Though most of the suggestion are related to Oracle APEX, you can get idea about how to about ORDS with AD SSO:
- Windows Integrated Authentication - HOWTO
- Options for Windows Native Authentication with APEX | W.P. Hill Tech
- The white-paper Single Sign-On for APEX Applications using Kerberos published by MT AG
Thanks for the links.
I worked it out in the end.
Posting here incase someone else get the same issue:
When assigning role security within ORDS (Pl/Sql) - the group needs to match the AD group name including domain prefix:
p_name => 'DOMAIN\Domain Users',
p_role_name => 'DOMAIN\Domain Users',
p_label => 'DOMAIN\Domain Users',
p_description => 'DOMAIN\Domain Users');
p_privilege_name => 'DOMAIN\Domain Users',
p_pattern => '/app_uri/*');