SQL Anywhere database - LOGIN_PROCEDURE and Integrated Login

Author

LOGIN_PROCEDURE and Integrated Login

David DeRam

2005-04-20, 11:23 am

From within the LOGIN_PROCEDURE is there any way to determine if the
connection is an integrated login?

Thank you for any insight.

The version is 9.0.1.

Breck Carter

2005-04-20, 8:23 pm

SELECT CONNECTION_PROPERTY ( 'LOGIN_MODE' );

> From within the LOGIN_PROCEDURE is there any way to
> determine if the connection is an integrated login?
>
> Thank you for any insight.
>
> The version is 9.0.1.
>
>

David DeRam

2005-04-20, 8:23 pm

oooh! if that worked it would have been *huge* :-)

But that is giving me the *database* level option. It returns either
Standard, Mixed, or Integrated. (It returns the option that specifies
whether integrated logins are permitted on the database).

I need a connection level parameter that tells me if the current connection
signed on with integrated login or not.

Thanks for any insight.

- it seems kind of strange that LOGIN_MODE is listed as a
CONNECTION_PROPERTY

<Breck Carter> wrote in message news:4266c30e.4190.1681692777@sybase.com...[color=darkred]
> SELECT CONNECTION_PROPERTY ( 'LOGIN_MODE' );
>

Breck Carter [TeamSybase]

2005-04-21, 7:23 am

Ooops, I was misled by that fact, should have realized "Mixed" made no
sense.

Here's a WAG... If you associate the integrated login with a user id
that is not used for direct connections, you could join SYSUSERPERM to
SYSLOGIN... if a child row exists in SYSLOGIN then it is an integrated
login.

Breck

On 20 Apr 2005 15:47:37 -0700, "David DeRam"
< ns_xxxdderam@progeny
ns_xxx2000.com> wrote:

>oooh! if that worked it would have been *huge* :-)
>
>But that is giving me the *database* level option. It returns either
>Standard, Mixed, or Integrated. (It returns the option that specifies
>whether integrated logins are permitted on the database).
>
>I need a connection level parameter that tells me if the current connection
>signed on with integrated login or not.
>
>Thanks for any insight.
>
>- it seems kind of strange that LOGIN_MODE is listed as a
>CONNECTION_PROPERTY
>
>
>
><Breck Carter> wrote in message news:4266c30e.4190.1681692777@sybase.com...
>

--
SQL Anywhere Studio 9 Developer's Guide
Buy the book: http://www.amazon.com/exec/obidos/A...7/risingroad-20
bcarter@risingroad.com
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com

Sponsored Links