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

asked 21 Nov '13, 11:58

jazz's gravatar image

jazz
16112
accept rate: 0%

edited 21 Nov '13, 12:53

Volker%20Barth's gravatar image

Volker Barth
40.1k361549819


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.

permanent link

answered 21 Nov '13, 12:52

Volker%20Barth's gravatar image

Volker Barth
40.1k361549819
accept rate: 34%

edited 21 Nov '13, 12:55

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
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×159
×24
×15
×13

question asked: 21 Nov '13, 11:58

question was seen: 2,518 times

last updated: 26 Nov '13, 06:54