How can i restrict the SA user

hi,
Is there any way to restrict the SA access. The problem is that all my
client machine users knows the sa password, and also right now i don't want
to change the password. So i just want to know is there any way to restrict
their access ? thanking in advance
ARHi
SA is not restrictable as it is the highest built in security account.
If security is so important, you have to change the password. Remember, if
you are using integrated security, domain and local admins are by default,
mapped to SA.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Aneesh" <aneesh.r@.eostek.com> wrote in message
news:u4iPss30EHA.2608@.TK2MSFTNGP10.phx.gbl...
> hi,
> Is there any way to restrict the SA access. The problem is that all my
> client machine users knows the sa password, and also right now i don't
want
> to change the password. So i just want to know is there any way to
restrict
> their access ? thanking in advance
> AR
>|||"Aneesh" <aneesh.r@.eostek.com> wrote in message
news:u4iPss30EHA.2608@.TK2MSFTNGP10.phx.gbl...
> hi,
> Is there any way to restrict the SA access. The problem is that all my
> client machine users knows the sa password, and also right now i don't
want
> to change the password. So i just want to know is there any way to
restrict
> their access ? thanking in advance
> AR
Make a new user and give him an appropriate permissions.
regards,
Dra

How can I remove "include report" option from the email subscripti

I don't want users to have the "include report" option when setting up an
email subscription. Is it possible? I want users to only be able to get a
link to the report to avoid attachments in the inbox.
I was expecting to be able to set it in RSReportServer.config file, but I
didn't find an option.The email delivery extension does not support this scenario. You could look
into writing your own delivery extension. Since all you want to do is email
a link it would be fairly simple to write, the hardest part would be the UI.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"JulioLe" <JulioLe@.discussions.microsoft.com> wrote in message
news:7E95C301-6D46-47E6-8E6C-CEDEC9A57CEA@.microsoft.com...
>I don't want users to have the "include report" option when setting up an
> email subscription. Is it possible? I want users to only be able to get a
> link to the report to avoid attachments in the inbox.
> I was expecting to be able to set it in RSReportServer.config file, but I
> didn't find an option.
>

How Can I Prevent any activity on a SQL Server

I'm getting close to migrating my db's across to a new server and wonder
what is the best way to prevent users from accessing any of the db's on the
sql server?
I have a very LARGE dts package to run that will do all the work for me but
it will be running on the destination server and not sure how I can prevent
anyone other than telling them not to attach to it.
One thought was to start the server in single instance mode but I'm
unfamiliar with how it works. I could reorg the dts to run on the source
server if the single instance will do the trick.

Thanks
Paul Bergson
How about putting the source DB in read only mode?
"Paul Bergson" <pbergson_nospam@.allete.com> wrote in message
news:%236$6oNoUFHA.2436@.TK2MSFTNGP10.phx.gbl...
> I'm getting close to migrating my db's across to a new server and wonder
> what is the best way to prevent users from accessing any of the db's on
> the
> sql server?
> I have a very LARGE dts package to run that will do all the work for me
> but
> it will be running on the destination server and not sure how I can
> prevent
> anyone other than telling them not to attach to it.
> One thought was to start the server in single instance mode but I'm
> unfamiliar with how it works. I could reorg the dts to run on the source
> server if the single instance will do the trick.
>
> --
> Thanks
> Paul Bergson
>
|||If you only have a few, you could do:
ALTER DATABASE dbName SET SINGLE_USER WITH ROLLBACK IMMEDIATE
Then hope your DTS package jumps in before anyone else does.
The downside is you will not be able connect directly to the database to
monitor anything... you will have to rely on the DTS package.
Another idea perhaps is to rename the database? Other applications that
expect it to be there will break, but if you have told the users the db
would be down/inaccessible, that's probably acceptable.
This is my signature. It is a general reminder.
Please post DDL, sample data and desired results.
See http://www.aspfaq.com/5006 for info.
"Paul Bergson" <pbergson_nospam@.allete.com> wrote in message
news:%236$6oNoUFHA.2436@.TK2MSFTNGP10.phx.gbl...
> I'm getting close to migrating my db's across to a new server and wonder
> what is the best way to prevent users from accessing any of the db's on
> the
> sql server?
> I have a very LARGE dts package to run that will do all the work for me
> but
> it will be running on the destination server and not sure how I can
> prevent
> anyone other than telling them not to attach to it.
> One thought was to start the server in single instance mode but I'm
> unfamiliar with how it works. I could reorg the dts to run on the source
> server if the single instance will do the trick.
>
> --
> Thanks
> Paul Bergson
>

How Can I Prevent any activity on a SQL Server

I'm getting close to migrating my db's across to a new server and wonder
what is the best way to prevent users from accessing any of the db's on the
sql server?
I have a very LARGE dts package to run that will do all the work for me but
it will be running on the destination server and not sure how I can prevent
anyone other than telling them not to attach to it.
One thought was to start the server in single instance mode but I'm
unfamiliar with how it works. I could reorg the dts to run on the source
server if the single instance will do the trick.
Thanks
Paul BergsonHow about putting the source DB in read only mode?
"Paul Bergson" <pbergson_nospam@.allete.com> wrote in message
news:%236$6oNoUFHA.2436@.TK2MSFTNGP10.phx.gbl...
> I'm getting close to migrating my db's across to a new server and wonder
> what is the best way to prevent users from accessing any of the db's on
> the
> sql server?
> I have a very LARGE dts package to run that will do all the work for me
> but
> it will be running on the destination server and not sure how I can
> prevent
> anyone other than telling them not to attach to it.
> One thought was to start the server in single instance mode but I'm
> unfamiliar with how it works. I could reorg the dts to run on the source
> server if the single instance will do the trick.
>
> --
> Thanks
> Paul Bergson
>|||If you only have a few, you could do:
ALTER DATABASE dbName SET SINGLE_USER WITH ROLLBACK IMMEDIATE
Then hope your DTS package jumps in before anyone else does.
The downside is you will not be able connect directly to the database to
monitor anything... you will have to rely on the DTS package.
Another idea perhaps is to rename the database? Other applications that
expect it to be there will break, but if you have told the users the db
would be down/inaccessible, that's probably acceptable.
This is my signature. It is a general reminder.
Please post DDL, sample data and desired results.
See http://www.aspfaq.com/5006 for info.
"Paul Bergson" <pbergson_nospam@.allete.com> wrote in message
news:%236$6oNoUFHA.2436@.TK2MSFTNGP10.phx.gbl...
> I'm getting close to migrating my db's across to a new server and wonder
> what is the best way to prevent users from accessing any of the db's on
> the
> sql server?
> I have a very LARGE dts package to run that will do all the work for me
> but
> it will be running on the destination server and not sure how I can
> prevent
> anyone other than telling them not to attach to it.
> One thought was to start the server in single instance mode but I'm
> unfamiliar with how it works. I could reorg the dts to run on the source
> server if the single instance will do the trick.
>
> --
> Thanks
> Paul Bergson
>sql

How Can I Prevent any activity on a SQL Server

I'm getting close to migrating my db's across to a new server and wonder
what is the best way to prevent users from accessing any of the db's on the
sql server?
I have a very LARGE dts package to run that will do all the work for me but
it will be running on the destination server and not sure how I can prevent
anyone other than telling them not to attach to it.
One thought was to start the server in single instance mode but I'm
unfamiliar with how it works. I could reorg the dts to run on the source
server if the single instance will do the trick.
--
Thanks
Paul BergsonHow about putting the source DB in read only mode?
"Paul Bergson" <pbergson_nospam@.allete.com> wrote in message
news:%236$6oNoUFHA.2436@.TK2MSFTNGP10.phx.gbl...
> I'm getting close to migrating my db's across to a new server and wonder
> what is the best way to prevent users from accessing any of the db's on
> the
> sql server?
> I have a very LARGE dts package to run that will do all the work for me
> but
> it will be running on the destination server and not sure how I can
> prevent
> anyone other than telling them not to attach to it.
> One thought was to start the server in single instance mode but I'm
> unfamiliar with how it works. I could reorg the dts to run on the source
> server if the single instance will do the trick.
>
> --
> Thanks
> Paul Bergson
>|||If you only have a few, you could do:
ALTER DATABASE dbName SET SINGLE_USER WITH ROLLBACK IMMEDIATE
Then hope your DTS package jumps in before anyone else does.
The downside is you will not be able connect directly to the database to
monitor anything... you will have to rely on the DTS package.
Another idea perhaps is to rename the database? Other applications that
expect it to be there will break, but if you have told the users the db
would be down/inaccessible, that's probably acceptable.
--
This is my signature. It is a general reminder.
Please post DDL, sample data and desired results.
See http://www.aspfaq.com/5006 for info.
"Paul Bergson" <pbergson_nospam@.allete.com> wrote in message
news:%236$6oNoUFHA.2436@.TK2MSFTNGP10.phx.gbl...
> I'm getting close to migrating my db's across to a new server and wonder
> what is the best way to prevent users from accessing any of the db's on
> the
> sql server?
> I have a very LARGE dts package to run that will do all the work for me
> but
> it will be running on the destination server and not sure how I can
> prevent
> anyone other than telling them not to attach to it.
> One thought was to start the server in single instance mode but I'm
> unfamiliar with how it works. I could reorg the dts to run on the source
> server if the single instance will do the trick.
>
> --
> Thanks
> Paul Bergson
>

How can I obtain a report of users and roles in SQL Server?

I need a query (script) or a tool to obtain a report (or audit report) for
all databases instanced into SQL Server, just for an entittlement review aun
audit reports.
The fields are:
User, role, permissions, last date access
Best regards to everyone.
JosSee:-
SYSPROTECT system table and system procedure SP_HELPROTECT
Thanks
Hari
SQL Server MVP
"Jos Archondo" <jarchondo@.spvs.gov.bo> wrote in message
news:uMv%23UlC1FHA.664@.tk2msftngp13.phx.gbl...
>I need a query (script) or a tool to obtain a report (or audit report) for
> all databases instanced into SQL Server, just for an entittlement review
> aun
> audit reports.
> The fields are:
> User, role, permissions, last date access
> Best regards to everyone.
> Jos
>|||You should also run sp_helplogins. That will help define where
sp_helprotect should be run.
RLF
"Jos Archondo" <jarchondo@.spvs.gov.bo> wrote in message
news:uMv%23UlC1FHA.664@.tk2msftngp13.phx.gbl...
>I need a query (script) or a tool to obtain a report (or audit report) for
> all databases instanced into SQL Server, just for an entittlement review
> aun
> audit reports.
> The fields are:
> User, role, permissions, last date access
> Best regards to everyone.
> Jos
>

How can I move a database?

Hi
I am having to move a database from one pc to another and would like to know
the best way to do so making sure that users and logins come across as well.
I am using MSDE 2000 Rel A and am moving it from a Windows 2000 pc to a
Windows XP Prof 2002 SP2 machine.
I have sucessfully installed MSDE on the new pc and can view it through
DBAMgr2k.
I need to know how to create the database and pull across all the
properties.
I tried generating an SQL script for all objects but when I tried to run it
on the XP machine (using DBAMgr2k) I received a "Count field incorrect or
syntax error" message.
Any help would be much appreciated.
Thanks
June
Hello,
Please read the article and go ahead based on the steps defined. This help
you to move all the user databases and system databases to new server.
Since you are moving the system databases you will get the Logins, users,
Jobs,... to the new environment automatically.
http://support.microsoft.com/kb/224071
Thanks
Hari
"June Macleod" <junemacleod@.btconnect.com> wrote in message
news:csKdncKr1KVXoD_YRVnyjQA@.bt.com...
> Hi
> I am having to move a database from one pc to another and would like to
> know
> the best way to do so making sure that users and logins come across as
> well.
> I am using MSDE 2000 Rel A and am moving it from a Windows 2000 pc to a
> Windows XP Prof 2002 SP2 machine.
> I have sucessfully installed MSDE on the new pc and can view it through
> DBAMgr2k.
> I need to know how to create the database and pull across all the
> properties.
> I tried generating an SQL script for all objects but when I tried to run
> it
> on the XP machine (using DBAMgr2k) I received a "Count field incorrect or
> syntax error" message.
> Any help would be much appreciated.
> Thanks
> June
>
|||That worked well.
Many thanks
June
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:%23g60%23WyMHHA.4992@.TK2MSFTNGP04.phx.gbl...
> Hello,
> Please read the article and go ahead based on the steps defined. This
help[vbcol=seagreen]
> you to move all the user databases and system databases to new server.
> Since you are moving the system databases you will get the Logins, users,
> Jobs,... to the new environment automatically.
> http://support.microsoft.com/kb/224071
> Thanks
> Hari
>
> "June Macleod" <junemacleod@.btconnect.com> wrote in message
> news:csKdncKr1KVXoD_YRVnyjQA@.bt.com...
or
>

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 lock a record

hi all iam working on a ticketing application i want to avoid two users to book the same ticket the requirement is as follows

1. the system should show all the available tickets which is not yet booked

2.when two users book the ticket at the same time time it should not allow the two persons to update at the same tme

the main aim is to avoid data concurency

how can i get this done

Use a flag or the best is to use time-stamps?

|||

Hi,

From your description, it seems that your problem is related to SQL concurrency issue.
Suppose each ticket is saved in your data table. For your first requirement, it can be achieved by using a flag which indicates if the ticket has been booked or not.
For your second requirement, since ADO.NET uses Optimistic Concurrency. Then locks are set and held only while the database is being accessed. The locks prevent other users from attempting to update records at the same instant. The data is always available except for the exact moment that an update is taking place.

In Optimistic Concurrency, there are two general ways to determine if changes have occurred: the version approach (true version numbers or date-time stamps) and the saving all values approach.

i.e. For Version Number approach, the record to be updated must have a column that contains a date-time stamp or version number. The date-time stamp or a version number is saved on the client when the record is read. This value is then made part of the update.

For more information, seehttp://msdn2.microsoft.com/en-us/library/cs6hb8k4(VS.71).aspx

Thanks!

How can I know?

I wanna know how I could know how many users or who are logging into some
database.
thanks in advanceYou can run sp_who2 and count the ones in the specific db. Or you can run a
select against master..sysprocesses and filter on the correct DBID.
Andrew J. Kelly SQL MVP
"hui" <jxmu_lhf71@.163.com> wrote in message
news:ODVQAhnGFHA.2280@.TK2MSFTNGP15.phx.gbl...
>I wanna know how I could know how many users or who are logging into some
> database.
> thanks in advance
>

How Can i know how many USERS are in agroup.

HI all
I just wana know that is there is any TSQL Statement which will give me
the list of all user groups,names of user in each group and thier
Permssions in any database/server.
Actually I have to create a report in wich i have to show that how
many groups we have any whi is the member of wich group with such
permissions.I ckeck through Interprise Manager but i guess it will take
alot of time to note every user group then users and their permissions.
So please any HELP will be greatly Appriciated.

Thanks

Arman(ch.adilaziz@.gmail.com) writes:

Quote:

Originally Posted by

I just wana know that is there is any TSQL Statement which will give me
the list of all user groups,names of user in each group and thier
Permssions in any database/server.
Actually I have to create a report in wich i have to show that how
many groups we have any whi is the member of wich group with such
permissions.I ckeck through Interprise Manager but i guess it will take
alot of time to note every user group then users and their permissions.
So please any HELP will be greatly Appriciated.

Before I try anything, I would like some clarification. With "groups" do
you mean what is normally called "roles" in SQL Server? That is grouping
of users within a database?

Or do you mean Windows groups as in DOMAIN\OFFICEUSERS?

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||Erland Sommarskog wrote:

Quote:

Originally Posted by

Before I try anything, I would like some clarification. With "groups" do
you mean what is normally called "roles" in SQL Server? That is grouping
of users within a database?
>
Or do you mean Windows groups as in DOMAIN\OFFICEUSERS?

Even if Arman meant roles, I'd like to ask you similar question
according to Windows groups. Is it possible to list Windows group
members using T-SQL? Let's assume that I'm a sysadmin, but not domain
admin.

--
Best regards,
Marcin Guzowski
http://guzowski.info|||Marcin A. Guzowski wrote:

Quote:

Originally Posted by

Erland Sommarskog wrote:

Quote:

Originally Posted by

Before I try anything, I would like some clarification. With "groups" do
you mean what is normally called "roles" in SQL Server? That is grouping
of users within a database?

Question #1:

Answer : Yes

sp_helpuser

Quote:

Originally Posted by

Quote:

Originally Posted by

Or do you mean Windows groups as in DOMAIN\OFFICEUSERS?

>
>
Even if Arman meant roles, I'd like to ask you similar question
according to Windows groups. Is it possible to list Windows group
members using T-SQL? Let's assume that I'm a sysadmin, but not domain
admin.
>
>

Question #2:

Answer: Yes, set up a linked server with your pdc server / active
directory and use open query to query this information from the linked
server.

http://www.fits-consulting.de/blog/...2e73b00faa.aspx

Quote:

Originally Posted by

--
Best regards,
Marcin Guzowski
http://guzowski.info

|||jebuskrust@.gmail.com wrote:

Quote:

Originally Posted by

Question #2:
>
Answer: Yes, set up a linked server with your pdc server / active
directory and use open query to query this information from the linked
server.
>
http://www.fits-consulting.de/blog/...2e73b00faa.aspx

I found much easier way:
exec master.dbo.xp_logininfo 'DOMAIN\GROUP','members'

It will list all members of desired Windows group*, without the need
of setting up a linked server.
[*] only groups granted access to SQL Server are concerned

--
Best regards,
Marcin Guzowski
http://guzowski.info

How can I get the log sequence number on C#?

Hi! I would like to get the log sequence number from the database backup so
that I can let the users select the restored time. Can I do this with the
SMO?
Thanks!One way would be to use methods such as the Database.ExecuteWithResults method to execute your
RESTORE HEADERONLY command and loop the result (DataTable in the DataSet) from that method.
Or, you should be able to use BackupDevice.ReadBackupHeader method and read the returned DataTable.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Cheryl" <justtosayhi@.excite.com> wrote in message
news:FBB10E85-25FF-49B7-96D4-97ADE7552575@.microsoft.com...
> Hi! I would like to get the log sequence number from the database backup so that I can let the
> users select the restored time. Can I do this with the SMO?
> Thanks!