Chapter 14: Managing Adaptive Server Logins, Database Users, and Client Connections

Viewing user roles in a hierarchy

Use role_contain to determine whether any role you specify contains any other role you specify:

role_contain (["role1", "role2"])

If role1 contains role2, role_contain returns 1.

Any user can execute role_contain.