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.
| Author |
Topic |
|
Kabila
Starting Member
33 Posts |
 Posted - 2009-09-24 : 08:05:46
|
| How to make a table read only in sql 2005? |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2009-09-24 : 08:13:35
|
| DENY INSERT, UPDATE, DELETE ON myTable TO publicThat should be a good start. |
 |
|
|
Kabila
Starting Member
33 Posts |
Posted - 2009-09-24 : 08:47:50
|
| Any other way? |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2009-09-24 : 09:04:02
|
quote:
Originally posted by Kabila
Any other way?
Why?What is wrong with the above suggestion?Another method is to create a view like this and give access to that view only (But may not be effecient)create view my_viewasselect columns from tableunionselect top 1 columns from tableMadhivananFailing to plan is Planning to fail |
|
|
|
Kabila
Starting Member
33 Posts |
Posted - 2009-09-24 : 09:21:10
|
| Database permission is not set by me. Any another way?Plz... |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2009-09-24 : 09:54:09
|
| Can't think of one except to write a trigger to always roll back. But if you can't set permissions on tables then it's unlikely you can create triggers. |
|
|
|
|
|
|
Table read only