Hi

I got the same situation where in I am creating workload groups based on database name. I will be using table to store the loginnames, database names and workload group names and classify to a WL group based on the default database or original database name. What if the login name is active directory group? My table has active directory group name listed as login name and when I query suser_name() or suser_sname(), it returns the user name who is member of the active directory group but doesn't return active directory group name. Any trick to find out that user belongs to a particular group name?

Thanks

Vicky