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.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
>|||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...
>>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
>|||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...
>>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
>|||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...
>> 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
>>
>
>

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,
Rui
You 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.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
>
|||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...
>
>

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...
>
>

hOW CAN i GET THE dts PACKAGES TO WORK WITH MSDE

I have masde Installation which have to execute dts packages to connect
to my sql server and load the data to the SQL databases.
Would anyone have any experience with this and know how to make this
work?

Thanking you in anticipation.

Ajay GargDTS works with MSDE in exactly the same way as MSSQL. The only
difference is that MSDE has no graphical client tools, so you don't
have the DTS package designer, but I guess you're probably designing
your packages on MSSQL anyway.

If you have a specific problem with DTS, then you should give more
details about exactly what you're trying to do, what errors or
unexpected results you get and so on. There's also a DTS newsgroup:
microsoft.public.sqlserver.dts.

Simon

how can i get database name using C#

can i get list of database name using C#.
i want to load it into combobox to easy to choice
thanks .

There is two choices are there

You can use SMO/DMO libraries

or

You can use the simple query from database

use Master
Select Name from SYSDatabases