I have a database that I'd like to prohibit any updates/inserts to.
Basically, I want it to be read-only. Is there an option somewhere to
do that?

--
..tom
remove email address' dashes for replies
The last calendar you'll ever need is at <http://www.coordidate.org/>
Opensource middleware at <http://isectd.sourceforge.net/>
<http://gagne.homedns.org/~tgagne/>

Thomas Gagné <tgagne (AT) wide-open-west (DOT) com> wrote

sp_dboption "dbname","read only",true
go

but even the dbo is not able anymore to update data, otherwise, you
could create a group including all users (except the dbo) and grant
them "select" only on objects.

"Bruno" <bruno.biets (AT) portima (DOT) com> wrote

I'm missing the point on "otherwise, you could create a group including all
users (except the dbo) and grant
them "select" only on objects." Upon further review, I see that the intent
is "only grant 'select' on objects".

It may also be that applications that are only doing reads may not be able
to "read", namely, if ANSI transaction mode (set autocommit on) is used.
Sybases' implementation will attempt to write empty begin/end transactions
to the log for your select statements and you will get errors for your
"read" executions.

Bruno wrote:


--
..tom
remove email address' dashes for replies
The last calendar you'll ever need is at <http://www.coordidate.org/>
Opensource middleware at <http://isectd.sourceforge.net/>
<http://gagne.homedns.org/~tgagne/>