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 |
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. was it not possible to use windows(or host os) authentication in asa 7 like sql anywhere 10 and onwards?
(22 Nov '13, 13:11)
G_G
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.
(25 Nov '13, 04:30)
Reimer Pods
Replies hidden
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.
(26 Nov '13, 06:54)
Volker Barth
|