Making "Server Management Studio" read only ?

Hi - I would like to be able to setup "Server Management Studio" so
that no changes can be made to the database/schemas (we write scripts
to make changes we want).
What's the best way to do this ?
Just to explain why - I want developers to be able to browse table
definitions etc but I want to ensure that no changes ever take place by
accident when doing so.
Thanks
Richard.Create a login which has only read only permissions. Take a look at
db_datareader fixed database role. The user should no be a member of
sysadmin server role
<shearichard@.gmail.com> wrote in message
news:1168142809.101663.284960@.i15g2000cwa.googlegroups.com...
> Hi - I would like to be able to setup "Server Management Studio" so
> that no changes can be made to the database/schemas (we write scripts
> to make changes we want).
> What's the best way to do this ?
> Just to explain why - I want developers to be able to browse table
> definitions etc but I want to ensure that no changes ever take place by
> accident when doing so.
> Thanks
> Richard.
>|||Uri Dimant wrote:
> Create a login which has only read only permissions. Take a look at
> db_datareader fixed database role. The user should no be a member of
> sysadmin server role
>
OK thanks I will try that. Reading the doco for db_datareader mentions
being able to read data but doesn't mention whether a db_datareader
will be able to read table definitions etc - maybe that's a given ?
Anyway thanks and I will try what you suggest.
regards
Richard.
> <shearichard@.gmail.com> wrote in message
> news:1168142809.101663.284960@.i15g2000cwa.googlegroups.com...
> > Hi - I would like to be able to setup "Server Management Studio" so
> > that no changes can be made to the database/schemas (we write scripts
> > to make changes we want).
> >
> > What's the best way to do this ?
> >
> > Just to explain why - I want developers to be able to browse table
> > definitions etc but I want to ensure that no changes ever take place by
> > accident when doing so.
> >
> > Thanks
> >
> > Richard.
> >|||<shearichard@.gmail.com> wrote in message
news:1168296784.941138.131700@.42g2000cwt.googlegroups.com...
> Uri Dimant wrote:
>> Create a login which has only read only permissions. Take a look at
>> db_datareader fixed database role. The user should no be a member of
>> sysadmin server role
> OK thanks I will try that. Reading the doco for db_datareader mentions
> being able to read data but doesn't mention whether a db_datareader
> will be able to read table definitions etc - maybe that's a given ?
> Anyway thanks and I will try what you suggest.
I believe they can.
> regards
>
> Richard.
>
>> <shearichard@.gmail.com> wrote in message
>> news:1168142809.101663.284960@.i15g2000cwa.googlegroups.com...
>> > Hi - I would like to be able to setup "Server Management Studio" so
>> > that no changes can be made to the database/schemas (we write scripts
>> > to make changes we want).
>> >
>> > What's the best way to do this ?
>> >
>> > Just to explain why - I want developers to be able to browse table
>> > definitions etc but I want to ensure that no changes ever take place by
>> > accident when doing so.
>> >
>> > Thanks
>> >
>> > Richard.
>> >
>