You are viewing limited content. For full access, please sign in.

Question

Question

2 users showing as Type 'Group' in Forms

asked on September 27, 2023

I have 2 user accounts that are showing as Type 'Group' in Forms. We are using LFDS authentication, and I am seeing this in all 4 Forms instances that have for the same 2 user accounts. Any idea what would cause that?

Forms version: 11.0.2212.30907 and 11.0.2307.40556

0 0

Replies

replied on September 27, 2023

Hi, could you please run the SQL strings below in your current database and provide the query result to us?

SELECT *
FROM [$DATABASE].[dbo].[cf_users]
WHERE username = '$Username1' 
OR username='$Username2'
SELECT *
FROM [$DATABASE].[dbo].[cf_usergroups]
WHERE full_group_name = '$Username1' 
OR full_group_name = '$Username2'

Replace '$DATABASE'  with the database you currently use. Replace the '$Username1' and '$Username2' with username of the two problematic accounts respectively, which can be grabbed on Administration page.

0 0
replied on September 28, 2023

Do you want me to open a support ticket with our solution provider to supply you with the results?

0 0
replied on September 28, 2023

Yes, please.

0 0
replied on September 28, 2023

A support ticket with our Solution Provider has been opened.

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.