The forum will experience an outage sometime between February 10 at 7:00pm EST and February 12 at 11:59 EST for installation of security updates. The actual time and duration of the outage are unknown but attempts will be made to minimize the downtime. We apologize for any inconvenience.

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
29.3k287438644


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
29.3k287438644
accept rate: 32%

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:

×123
×17
×13
×10

question asked: 21 Nov '13, 11:58

question was seen: 656 times

last updated: 26 Nov '13, 06:54