How can I make a table read only

I was wondering if there is a way to make a table read only. I tried doing
this through permissions, but the users are still able to load data into the
table through the application.
Any ideas?
Thanks in advance,
RuiYou can create instead of triggers that does nothing, for example. Note that
some bulk loading
utilities bypasses triggers, though.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Rui Peres" <peresr@.southcoast.org> wrote in message news:un1RUFe%23FHA.2324@.TK2MSFTNGP11.ph
x.gbl...
>I was wondering if there is a way to make a table read only. I tried doing
this through
>permissions, but the users are still able to load data into the table throu
gh the application.
> Any ideas?
> Thanks in advance,
> Rui
>|||assuming that the table has been given only select rights to this user then
it should work.
stupid question, but have you confirmed the correct user account being used
in your application is the correct user you are giving select rights too?
Also, check that the user is not in a sysadmin group.
Immy
"Rui Peres" <peresr@.southcoast.org> wrote in message
news:un1RUFe%23FHA.2324@.TK2MSFTNGP11.phx.gbl...
>I was wondering if there is a way to make a table read only. I tried doing
>this through permissions, but the users are still able to load data into
>the table through the application.
> Any ideas?
> Thanks in advance,
> Rui
>|||This is a database backend for a third-party application, and the user is in
the System Administrators group. I can not take the user out of the group,
though. What happens is that various users access this application, and
through the application they can load data into several 'datasets' which in
turn the system loads the data into the tables. I wanted to have a way to
prevent that on the back end since the app does not give me that option.
Am I stuck with the possibility that data may be loaded onto the table?
Thanks again,
Rui
"Immy" <imtiaz_ullah@.hotmail.com> wrote in message
news:%23q5MsLe%23FHA.3340@.TK2MSFTNGP12.phx.gbl...
> assuming that the table has been given only select rights to this user
> then it should work.
> stupid question, but have you confirmed the correct user account being
> used in your application is the correct user you are giving select rights
> too?
> Also, check that the user is not in a sysadmin group.
> Immy
> "Rui Peres" <peresr@.southcoast.org> wrote in message
> news:un1RUFe%23FHA.2324@.TK2MSFTNGP11.phx.gbl...
>|||You should be able to do it through permissions, unless the app is
connecting as the table owner, db owner or sysadmin.
Another alternative is to put the table on its own filegroup and set the
filegroup property to readonly.
HTH
Kalen Delaney, SQL Server MVP
www.solidqualitylearning.com
"Rui Peres" <peresr@.southcoast.org> wrote in message
news:un1RUFe%23FHA.2324@.TK2MSFTNGP11.phx.gbl...
> I was wondering if there is a way to make a table read only. I tried
> doing this through permissions, but the users are still able to load data
> into the table through the application.
> Any ideas?
> Thanks in advance,
> Rui
>|||OK, so sysadmin will have access.
Unless Kalens suggestion works, by placing the table on a different
filegroup but i'm still not so sure it will work, but cant comment as ive
never done it.
Immy
"Immy" <imtiaz_ullah@.hotmail.com> wrote in message
news:%23q5MsLe%23FHA.3340@.TK2MSFTNGP12.phx.gbl...
> assuming that the table has been given only select rights to this user
> then it should work.
> stupid question, but have you confirmed the correct user account being
> used in your application is the correct user you are giving select rights
> too?
> Also, check that the user is not in a sysadmin group.
> Immy
> "Rui Peres" <peresr@.southcoast.org> wrote in message
> news:un1RUFe%23FHA.2324@.TK2MSFTNGP11.phx.gbl...
>|||Would there be any issues with moving the table into a read only db &
replacing it with a view in the source db?
I've not actually done this - just thinking aloud..
Regards,
Greg Linwood
SQL Server MVP
"Kalen Delaney" <replies@.public_newsgroups.com> wrote in message
news:%23XLW%23ge%23FHA.3064@.TK2MSFTNGP10.phx.gbl...
> You should be able to do it through permissions, unless the app is
> connecting as the table owner, db owner or sysadmin.
> Another alternative is to put the table on its own filegroup and set the
> filegroup property to readonly.
> --
> HTH
> Kalen Delaney, SQL Server MVP
> www.solidqualitylearning.com
>
> "Rui Peres" <peresr@.southcoast.org> wrote in message
> news:un1RUFe%23FHA.2324@.TK2MSFTNGP11.phx.gbl...
>
>