Something is just not right here. First, I should be able to create my own user under a table space that I decide upon.
Second, when it creates the user (dataset), it does not set priveleges correctly. The Oracle schema uses function based indexes, which means that certain privileges need to be granted. Right now, the setup fails while trying to create the indexes. The only way for this to work is for the user creating the indexes to have QUERY REWRITE, which is not the case by default. Has anyone used the web interface to install under Oracle? > On Fri, 7 Jun 2002, John Proctor wrote: > > I have a user sqlledger in his own table space. How do I get the tables > > installed into the schema of user sqlledger? > > the word tablespace is an error i believe ... it just wants an account > that it can use to create users with if your trust yourself you could use > 'system/manager' (or simular) during the dataset creation > each dataset is a oracle user/schemea ... each user initial password is > the dataset name. > when you create a SL user ... the dataset user/password needs to be > given (thats what its looking for) when you read into the tablespace > aspects of things you sort of get the feeling that it was going to so > something very very serious involing oracle users for each SL user. this > is not the case > > --- > Gabriel C. Millerd | I know not with what weapons World War III will be > Sith Admin | fought, but World War IV will be fought with sticks > > | and stones. -Albert Einstein > > _______________________________________________________________ > > Don't miss the 2002 Sprint PCS Application Developer's Conference > August 25-28 in Las Vegas - > http://devcon.sprintpcs.com/adp/index.cfm?source=osdntextlink > > _______________________________________________ > Listinfo https://lists.sourceforge.net/lists/listinfo/sql-ledger-users > Archive http://www.geocrawler.com/redir-sf.php3?list=sql-ledger-users _______________________________________________________________ Don't miss the 2002 Sprint PCS Application Developer's Conference August 25-28 in Las Vegas - http://devcon.sprintpcs.com/adp/index.cfm?source=osdntextlink _______________________________________________ Listinfo https://lists.sourceforge.net/lists/listinfo/sql-ledger-users Archive http://www.geocrawler.com/redir-sf.php3?list=sql-ledger-users
