You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

how to join ASE_USER_CATEGORY_B and PER_USERS tables to get the USER_CATEGORY in a BIP report?

Summary:

PER_USERS has the list of users and ASE_USER_CATEGORY_B has the list of user categories, is there a way to join them and figure out the user category?

PER_LDAP_USERS table might not be the correct table as it doesn't list all the service accounts.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!