SQL Anywhere Mobile - mobilink and ASA login

Author

mobilink and ASA login

Eric Verhorstert

2005-07-13, 11:24 am

Is it possible to create a ASA user with a password that can only be
used by mobilink and by no other application. In this way I can prevent
users from logging in to our database with external applications.

This should be possible for both the mobilink client and the mobilink
server.

Thnaks
Eric

David Fishburn

2005-07-13, 8:25 pm

Eric Verhorstert <ontsnapt@hotmail.com> wrote in news:42d52e62$1@foru
ms-
2-dub
of sybase.public.sqlanywhere.mobilink:

EV> Is it possible to create a ASA user with a password that can only be
EV> used by mobilink and by no other application. In this way I can
prevent
EV> users from logging in to our database with external applications.
EV>
EV> This should be possible for both the mobilink client and the mobilink
EV> server.

I believe this would be possible, bear with me...

1. Write your own stored procedure, sp_login_procedure.
ASA Database Administration Guide
Database Options
Alphabetical list of options
LOGIN_PROCEDURE option [database]

2. From within that stored procedure, you can reference the AppInfo
field.
ASA Database Administration Guide
Connection Parameters and Network Protocol Options
Connection parameters
AppInfo connection parameter [APP]

3. From within the AppInfo data, I believe you can determine if this is
a Mobilink connection or not. This is the big unknown, you will
have to see what kind of information it provides.

Based on this information and the example listed in step 1, you can
choose to reject the login request.

--
David Fishburn
Certified ASA Developer Version 8
iAnywhere Solutions - Sybase
Professional Services
Please only post to the newsgroup
Please ALWAYS include version and MORE importantly BUILD number with
EACH post (dbeng9 -v).

EBFs and Maintenance Releases
http://downloads.sybase.com/swx/sdmain.stm

Developer Community / Whitepapers
http://www.ianywhere.com/developer

CaseXpress - to report bugs
http://casexpress.sybase.com

CodeXchange - Free samples
[url]http://ianywhere.codexchange.sybase.com/servlets/ ProjectDocumentList[
/url]

Eric Verhorstert

2005-07-15, 3:25 am

Thanks

David Fishburn wrote:
> Eric Verhorstert <ontsnapt@hotmail.com> wrote in news:42d52e62$1@foru
ms-
> 2-dub
> of sybase.public.sqlanywhere.mobilink:
>
> EV> Is it possible to create a ASA user with a password that can only be
> EV> used by mobilink and by no other application. In this way I can
> prevent
> EV> users from logging in to our database with external applications.
> EV>
> EV> This should be possible for both the mobilink client and the mobilink
> EV> server.
>
> I believe this would be possible, bear with me...
>
> 1. Write your own stored procedure, sp_login_procedure.
> ASA Database Administration Guide
> Database Options
> Alphabetical list of options
> LOGIN_PROCEDURE option [database]
>
> 2. From within that stored procedure, you can reference the AppInfo
> field.
> ASA Database Administration Guide
> Connection Parameters and Network Protocol Options
> Connection parameters
> AppInfo connection parameter [APP]
>
> 3. From within the AppInfo data, I believe you can determine if this is
> a Mobilink connection or not. This is the big unknown, you will
> have to see what kind of information it provides.
>
> Based on this information and the example listed in step 1, you can
> choose to reject the login request.
>

Sponsored Links