Can a database be put into read-only mode?

Thomas Gagné wrote in message news:...
> 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?

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" wrote in message
news:f4878324.0406170021.2b661b1a@posting.google.com...
> Thomas Gagné wrote in message
news:...
> > 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?
>
> 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.

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:

>Thomas Gagné wrote in message news:...
>
>
>>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?
>>
>>
>
>sp_dboption "dbname","read only",true
>go
>
>
That's perfect -- and I don't want the dbo to have write access.

--
..tom
remove email address' dashes for replies
The last calendar you'll ever need is at
Opensource middleware at