|
Home > Archive > SQL Anywhere Mobile > June 2005 > Is there any Stored Procedure to add a MobiLink user into an Oracle consolidated database?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Is there any Stored Procedure to add a MobiLink user into an Oracle consolidated database?
|
|
|
| 9.0.2.2451
The consolidated database is Oracle 9i. I have run syncora.sql provided in
the MobiLink installation already.
I am going to have a client application which allows the user to input
username
and password to create a MobiLink user in the consolidated database. Is
there
is any Oracle Stored Procedure to add the MobiLink user into the
consolidated
database? If not, writing a stored procedure is fine for me, but how is the
hashed
password generated?
Thanks in advance!
(PS: I do not prefer calling the command dbmluser to create the user.)
| |
|
| Moreover, I find that the Oracle stored procedure "ML_ADD_USER" doesn't
accept password as parameter, so that doesn't suit my need.
"Roy" <abc@abc.com> wrote in message news:42b7d4f1$1@foru
ms-2-dub...
> 9.0.2.2451
>
> The consolidated database is Oracle 9i. I have run syncora.sql provided
> in
> the MobiLink installation already.
>
> I am going to have a client application which allows the user to input
> username
> and password to create a MobiLink user in the consolidated database. Is
> there
> is any Oracle Stored Procedure to add the MobiLink user into the
> consolidated
> database? If not, writing a stored procedure is fine for me, but how is
> the hashed
> password generated?
>
> Thanks in advance!
>
> (PS: I do not prefer calling the command dbmluser to create the user.)
>
| |
| Reg Domaratzki \(iAnywhere Solutions\) 2005-06-21, 11:24 am |
| The only way to add a user to the ml_user table and include the password
(regardless of the consolidated type) is to use the dbmluser command line
utility or to add the user through the MobiLink plug-in in Sybase Central.
--
Reg Domaratzki, Sybase iAnywhere Solutions
Sybase Certified Professional - Sybase ASA Developer Version 8
Please reply only to the newsgroup
iAnywhere Developer Community : http://www.ianywhere.com/developer
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
ASA Patches and EBFs : http://downloads.sybase.com/swx/sdmain.stm
-> Choose SQL Anywhere Studio
-> Set "Platform Preview" and "Time Frame" to ALL
"Roy" <abc@abc.com> wrote in message news:42b7d4f1$1@foru
ms-2-dub...
> 9.0.2.2451
>
> The consolidated database is Oracle 9i. I have run syncora.sql provided
in
> the MobiLink installation already.
>
> I am going to have a client application which allows the user to input
> username
> and password to create a MobiLink user in the consolidated database. Is
> there
> is any Oracle Stored Procedure to add the MobiLink user into the
> consolidated
> database? If not, writing a stored procedure is fine for me, but how is
the
> hashed
> password generated?
>
> Thanks in advance!
>
> (PS: I do not prefer calling the command dbmluser to create the user.)
>
>
|
|
|
|
|