I am new to Sybase having been an Oracle user for the longest time. I am working with a Database user that has no Password but is a Member of a group. What I need to understand is how is this user able to connect to the database?
I am not clear on how it does it.
Users without a password simply cannot connect to the database. They are usually just used to own database objects, usually as users that are groups. Apparently, a DBA must connect and create/alter objects in their name.
Cf. this doc topic - it's from the v12 docs but AFAIK it is valid for older versions, too:
If that user is not a group herself, then I guess the only reasonable usage case IMHO would to be that a DBA would connect and then use SETUSER to impersonate that user.