password protecting data

Hi,

I need to provide a facility to do routine database administration
(backups, etc.) without allowing the logged in user to modify the
data in any of the SQL server tables. Is there any way to accomplish
this (such as maybe password protecting the tables or otherwise)? I am
fairly new to SQL server - so would appreciate any pointers to this.

Thanks a ton!

Regards,
Radha"M.C. Radhakrishnan" <radhakrishnan_c@.infosys.com> wrote in message
news:e76f8e68.0405270436.54de116b@.posting.google.c om...
> Hi,
> I need to provide a facility to do routine database administration
> (backups, etc.) without allowing the logged in user to modify the
> data in any of the SQL server tables. Is there any way to accomplish
> this (such as maybe password protecting the tables or otherwise)? I am
> fairly new to SQL server - so would appreciate any pointers to this.

Sounds like you want to use ROLES and use db_backupoperator.
> Thanks a ton!
> Regards,
> Radha