Hello.

I want to have web site finalized with content, and then have a sql user with read only access to the db.

I tried, but it fails, because the user needs execute access to stored procudes as well. and hence will have write access too ....

is it by any means possible to access the db with a user with dataread access, and have the site working? (I expect nothing to be written to db)

I tried the trick. but it doesn't work.

I created a fresh site with db1, managed to use it as mainDB, created a normal connection for it, then added another db, db2, as writeConnection.

I tested it with two connection strings.

on application start, it runs the mojoportal-core script correctly on db2.

but it then tries to run 'mp_schemaVersion_SelectOne' on db1, and fails.

any suggestions?

I retried with two fresh dbs. it doesn't work. version: 2.3.5.9 MSSQL

sorry. I guess I misunderstood you. you mean the user has full access to both DBs, but writes to a separate db? if you mean this, well this works. I was testing with user having read access to the mainDB.

but I will need to make sure anywhere a write happens, it will use the writeConnectionString.

excuseme for asking this but have you been carefull with using the writeConnectionString anywhere you needed a write to the db? or there could be some places you missed and used the normal connection for writing to db?

what makes it different?

I created two fresh dbs.

then ran setup for the first db. home came up. again for the second. again home. I though by this point both dbs are Identical and there is no need for backup and restore.

i tried considering the home as the only page and the final content for the test.

then tried changing the application pool user, by a user which had read access to the normal db, and write access to the db with which it connected by writeConnectionString.

it didn't work.

failed on mp_schemaVersion_SelectOne.

Joe, thanks for helping.

Oh my god. sorry for complaining Joe!

I'll try that.