Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Verify thats you can read the data but not modify

Author  Topic 

sha1023012
Starting Member

4 Posts

Posted - 2013-03-06 : 20:40:28
Hello everyone I am learning how to restore a database. I am being ask to verify that you can read the data but not modify it and Verify that the departments that were added are missing from the database. This is my second attempt to do the restore I dont know if I type something in wrong the last time so my question is what would be the codes to do the verify so I am not putting the restore in an online mode cause thats what I think i did the last time.Thanks

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2013-03-07 : 01:00:12
[code]ALTER DATABASE <db name> SET READ_ONLY;[/code]
Go to Top of Page

yadhu_cse
Constraint Violating Yak Guru

252 Posts

Posted - 2013-03-07 : 01:34:29
Hi,
Give Read only access to the user. if you give read only access to databse then no one can modify the data. if you want to restrict data to be modified for particular user then you have set at access level.
Go to Top of Page

MIK_2008
Master Smack Fu Yak Hacker

1054 Posts

Posted - 2013-03-07 : 06:21:40
Once you restore the database, then execute the statment Russell mentioned. That will turn that database to be only in ReadOnly mode.

Cheers
MIK
Go to Top of Page
   

- Advertisement -