Row Lock

I have my password table and will like to lock one of the rows in order not to allow anyone change it since it is being used by my applications.
Please let me know.
Thanks...
Stoko
What do you mean that you have a password table?
Is this part of the sysxlogins? Did you create your own security tables?
Some additional information might be helpful.
On a side note, I don't think that there is a way to keep people from
working with an individual row in the table other than to use some type of
view that has permissions on it, or to create column level permissions on
the table itself.
Rick Sawtell
"stoko" <stoko@.discussions.microsoft.com> wrote in message
news:7461A023-256D-4449-8EFF-49F5EF6F74F1@.microsoft.com...
> I have my password table and will like to lock one of the rows in order
not to allow anyone change it since it is being used by my applications.
> Please let me know.
> Thanks...
> Stoko
|||Rick,
This table is a userdefined table I created with logins/pwd fields. You may be right that I should do a column level lock than row level. How then is this done?
Thanks...Stoko
"Rick Sawtell" wrote:

> What do you mean that you have a password table?
> Is this part of the sysxlogins? Did you create your own security tables?
> Some additional information might be helpful.
> On a side note, I don't think that there is a way to keep people from
> working with an individual row in the table other than to use some type of
> view that has permissions on it, or to create column level permissions on
> the table itself.
> Rick Sawtell
>
> "stoko" <stoko@.discussions.microsoft.com> wrote in message
> news:7461A023-256D-4449-8EFF-49F5EF6F74F1@.microsoft.com...
> not to allow anyone change it since it is being used by my applications.
>
>
|||Stoko,
How would a user update a password in this table? Can a user access the
table directly, or are they only able to do it via an application and you
are just trying to prevent a user from changing that password via that
screen?
"stoko" <stoko@.discussions.microsoft.com> wrote in message
news:1461F42D-921F-4F41-8CB3-38EDEAD7FB4D@.microsoft.com...
> Rick,
> This table is a userdefined table I created with logins/pwd fields. You
may be right that I should do a column level lock than row level. How then
is this done?[vbcol=seagreen]
> Thanks...Stoko
> "Rick Sawtell" wrote:
tables?[vbcol=seagreen]
of[vbcol=seagreen]
on[vbcol=seagreen]
order[vbcol=seagreen]
|||SQL is big time DB - meant for many, many users.
You should not have the client hold locks on the DB at all - imagine hundreds of users holding locks on PC's all around a WAN - what a nightmare.
You need to handle updates differently. Only allow an update if the row hasn't been changed since you read it. By using a datetime field - or checking that the value you are about to update hasn't changed.
Many different ways to handle this - but a major change in mind-set.
"slamm" wrote:

> Stoko,
> How would a user update a password in this table? Can a user access the
> table directly, or are they only able to do it via an application and you
> are just trying to prevent a user from changing that password via that
> screen?
>
> "stoko" <stoko@.discussions.microsoft.com> wrote in message
> news:1461F42D-921F-4F41-8CB3-38EDEAD7FB4D@.microsoft.com...
> may be right that I should do a column level lock than row level. How then
> is this done?
> tables?
> of
> on
> order
>
>