SQL Anywhere Mobile - Oracle 9 consolidated database

Author

Oracle 9 consolidated database

Philippe Damerval

2005-05-02, 8:24 pm

Hello,

I have been looking at the documentation on synchronizing with an Oracle
database. It mentions that the scripts required to be run in order to
turn the Oracle database into a consolidated database for
synchronization purposes need to be run by the System user. Is this the
case? Could I not create a schema "MYSCHEMA" on my Oracle instance and
run the scripts under that schema? This is a central, common database
over which I have no ability to connect with the SYSTEM user. I do have
full rights to my schema, including data files and dropping/creating tables.

Thanks!

--

Philippe Damerval
Alaska Dept. of Fish & Game
Commercial fisheries division

Reg Domaratzki

2005-05-03, 7:24 am

The reference you were seeing about using the SYSTEM account was in the
tutorial I think. Tutorials are much simplified when using a user with no
restrictions.

No, you do not need to be SYSTEM to create the tables. As long as the
account has permissions to create tables, procedures, views, and indexes,
the script should run. YOu'll also need to make sure that the user that is
used by Mobilink when it's running has insert/update and delete permissions
on the tables you reference in your synchronization scripts.

--
Reg Domaratzki, Sybase iAnywhere Solutions
Certified SQL Anywhere Associate
Please reply only to the newsgroup

ASA Patches and EBFs : http://downloads.sybase.com/swx/sdmain.stm
-> Choose SQL Anywhere Studio
-> Set "Platform Preview" and "Time Frame" to ALL and click "GO"

"Philippe Damerval" < philippe_damerval@fi
shgame.state.ak.us> wrote in
message news:4276c1da@forums
-1-dub...
> Hello,
>
> I have been looking at the documentation on synchronizing with an Oracle
> database. It mentions that the scripts required to be run in order to
> turn the Oracle database into a consolidated database for
> synchronization purposes need to be run by the System user. Is this the
> case? Could I not create a schema "MYSCHEMA" on my Oracle instance and
> run the scripts under that schema? This is a central, common database
> over which I have no ability to connect with the SYSTEM user. I do have
> full rights to my schema, including data files and dropping/creating
tables.
>
> Thanks!
>
> --
>
> Philippe Damerval
> Alaska Dept. of Fish & Game
> Commercial fisheries division

Breck Carter

2005-05-03, 9:23 am

You also need to use the same user id to run the syncora.sql
script as you are going to use with MobiLink when connecting
to the Oracle database; either that, or create synonyms for
all the ml_* objects created by syncora.sql.

Breck

> The reference you were seeing about using the SYSTEM
> account was in the tutorial I think. Tutorials are much
> simplified when using a user with no restrictions.
>
> No, you do not need to be SYSTEM to create the tables. As
> long as the account has permissions to create tables,
> procedures, views, and indexes, the script should run.
> YOu'll also need to make sure that the user that is used
> by Mobilink when it's running has insert/update and delete
> permissions on the tables you reference in your
> synchronization scripts.
>
> --
> Reg Domaratzki, Sybase iAnywhere Solutions
> Certified SQL Anywhere Associate
> Please reply only to the newsgroup
>
> ASA Patches and EBFs :
> http://downloads.sybase.com/swx/sdmain.stm
> -> Choose SQL Anywhere Studio
> -> Set "Platform Preview" and "Time Frame" to ALL and
> click "GO"
>
>
> "Philippe Damerval"
> < philippe_damerval@fi
shgame.state.ak.us> wrote in message
> synchronization purposes need to be run by the System
> over which I have no ability to connect with the SYSTEM
> files and dropping/creating tables.
>
>

Sponsored Links