Hi Matthew This is a privilege issue in the database and nothing to do with FME Get your DBA to look at what Object privileges the LANDBASE_UPDATE account has on the tables you're trying to write to.
So if you want to read from table PARCEL the LANDBASE_UPDATE account needs to have SELECT privilege granted to it, again if you need to change any existing rows of data in that table then the account would have to have UPDATE access granted to it and if you want to load and new rows then it would need INSERT granted to it and finally if you want to delete rows then the account would have to have DELETE granted to it. The sqlplus commands for doing this are: GRANT SELECT ON landbase_main.parcel TO landbase_update; GRANT UPDATE ON landbase_main.parcel TO landbase_update; GRANT INSERT ON landbase_main.parcel TO landbase_update; GRANT DELETE ON landbase_main.parcel TO landbase_update; These commands can either be run from the LANDBASE_MAIN account or by the DBA from a suitably privileged account This is assuming that the table already exists in the landbase_main schema, if it doesn't exist then you'll have to use the landbase_main account to create the table and then grant the relevant access. A couple of final this is that the Oracle table must have the spatial reference id and dimension values populated And when specifying the PARCEL table in FME you have to put the schema name in front of it, ie LANDBASE_MAIN.PARCEL, that if you are connecting as the LANDBASE_UPDATE account Good Luck Mark --- In [email protected], "Matthew Smart" <[EMAIL PROTECTED]> wrote: > > Hi Scott, sorry for the confussion the oracle users are > named "LANDBASE_UPDATE" and "LANDBASE_MAIN". > > So I have a table LANDBASE_MAIN.PARCEL > -- When I run the load as user "LANDBASE_MAIN" it works fine. But > our DBA wants us to use another user (without DROP or CREATE table > priv.) to load the data. > -- When I run the translation as user "LANDBASE_UPDATE" FME does > not appear to be able to see the table and tries to create a new > table called "LANBASE_MAIN_PARCEL" (note the "_" between table owner > and tablename). > > regards > Matthew > > --- In [email protected], "Scott Wilger" <[EMAIL PROTECTED]> wrote: > > > > Matthew, > > > > I don't know this for sure, but you may be having trouble because > you > > named your user UPDATE. This is definitely a reserved word in > Oracle, > > and I'm a little surprised that you were able to create a user > with that > > name. Try creating a user with a different name, grant the same > > privileges, and give it another shot. Just an idea, > > > > Scott Wilger > > Denver, CO USA > > > > -----Original Message----- > > From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of > > Matthew Smart > > Sent: Sunday, November 20, 2005 6:35 PM > > To: [email protected] > > Subject: [fme] FME Creates new Oracle table as current user > > > > I have created a number of oracle tables under the oracle > > username "MAIN" and created public synonyms for them. I then > granted > > another user "UPDATE" with Select, update, insert privlidges to > > these. When FME trys to load data as the UPDATE user it seems to > look > > for a table under the current username e.g. UPDATE.PARCEL, and > when it > > finds this doesn't exist it tries to create it. The UPDATE user > does > > not have permission to create tables. If I add the table owner to > the > > FME source dataset definition it puts a "_" rather than a "." > between > > the oracle username and the table and gets "MAIN_PARCEL", and as > this > > doesn't exist it, once again, tries to create a new table > > UPDATE.MAIN_PARCEL. > > > > Why does it use "_" between Oracle user and table name? Is there > a > > setting for this? > > > > regards > > Matthew Smart > > Brisbane Australia > > > > > > > > > > > > > > > > Get the maximum benefit from your FME, FME Objects, or > SpatialDirect via > > our Professional Services team. Visit www.safe.com/services for > > details. > > Yahoo! Groups Links > > > Get the maximum benefit from your FME, FME Objects, or SpatialDirect via our Professional Services team. Visit www.safe.com/services for details. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/fme/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
