Sybase ASA 7 Connect issue

[Former Member]

Hello,

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.

Thanks

[VolkerBarth]

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:

Groups without passwords

---

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.

[Former Member]

was it not possible to use windows(or host os) authentication in asa 7 like sql anywhere 10 and onwards?

[reimer_pods]

Basically it's possible, but it requires to be activated previously.

GRANT INTEGRATED LOGIN
TO windowsuser
AS USER dbuserA

And I doubt that being the case.

[VolkerBarth]

Technically said, even then, an integrated login can only connect when the according database user has a password.

However, from an OS user's point of view, it will appear as if the login process would be successful without a password - the database connection will be validated with the OS/domain credentials.

@jazz: If that is the situation you have noticed then I guess my answer was technially right but did not relate to integrated logins. When configured correctly, those can be used to connect successfully and do not require a password.