Suppose a SQL Server 7.0 database table has, say, 9 columns
[Column1...Column9] & only 3 users can access this table. Each user
has a password. Assume that the passwords of the 3 users are 'pwd1',
'pwd2' & 'pwd3' (without the quotes).
I want that if the password is 'pwd1', then that user should be allowed
to access the records of the columns Column1, Column2 & Column3. If the
password is 'pwd2', then that user should be allowed to access the
records of the columns Column4, Column5 & Column6. If the password is
'pwd3', then that user should be allowed to access the records of the
columns Column7, Column8 & Column9.
Now is it possible to assign permissions to these 3 users column-wise
on such a table so that the first user can access the first 3 columns,
the second user can access the next 3 columns & the third user can
access the last 3 columns exisitng in that table? If so, how do I do
this?
Please note that by "access", I mean the user can do anything with the
records (edit them or delete them).
Thanks,
ArpanIt is possible to assign permissions on a per-column basis:
grant all on MyTable(MyCol1, MyCol2) to User1
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
"Arpan" <arpan_de@.hotmail.com> wrote in message
news:1125796276.421444.185340@.g47g2000cwa.googlegroups.com...
> Suppose a SQL Server 7.0 database table has, say, 9 columns
> [Column1...Column9] & only 3 users can access this table. Each user
> has a password. Assume that the passwords of the 3 users are 'pwd1',
> 'pwd2' & 'pwd3' (without the quotes).
> I want that if the password is 'pwd1', then that user should be allowed
> to access the records of the columns Column1, Column2 & Column3. If the
> password is 'pwd2', then that user should be allowed to access the
> records of the columns Column4, Column5 & Column6. If the password is
> 'pwd3', then that user should be allowed to access the records of the
> columns Column7, Column8 & Column9.
> Now is it possible to assign permissions to these 3 users column-wise
> on such a table so that the first user can access the first 3 columns,
> the second user can access the next 3 columns & the third user can
> access the last 3 columns exisitng in that table? If so, how do I do
> this?
> Please note that by "access", I mean the user can do anything with the
> records (edit them or delete them).
> Thanks,
> Arpan
>
Showing posts with label password. Show all posts
Showing posts with label password. Show all posts
Sunday, March 11, 2012
Monday, February 13, 2012
ASP.NET Query
I need to display certain files from a directory based on a password. Could
someone point me in the right direction on how to do this. In my database i
store the file name and the password entered on the upload of the document.
When a user comes to download the document he/she needs to enter a password
before seeing any of the files available.
thanks in adv. for any and all help.I'm not sure I understand - can you elaborate? If you are already asking the
m
for a name and password for the upload, why not use that same method for the
download?
"Ben" wrote:
> I need to display certain files from a directory based on a password. Coul
d
> someone point me in the right direction on how to do this. In my database
i
> store the file name and the password entered on the upload of the document
.
> When a user comes to download the document he/she needs to enter a passwor
d
> before seeing any of the files available.
> thanks in adv. for any and all help.
someone point me in the right direction on how to do this. In my database i
store the file name and the password entered on the upload of the document.
When a user comes to download the document he/she needs to enter a password
before seeing any of the files available.
thanks in adv. for any and all help.I'm not sure I understand - can you elaborate? If you are already asking the
m
for a name and password for the upload, why not use that same method for the
download?
"Ben" wrote:
> I need to display certain files from a directory based on a password. Coul
d
> someone point me in the right direction on how to do this. In my database
i
> store the file name and the password entered on the upload of the document
.
> When a user comes to download the document he/she needs to enter a passwor
d
> before seeing any of the files available.
> thanks in adv. for any and all help.
Sunday, February 12, 2012
ASP.net app error after changing sa password
Hello,
I changed the sa password and now i get the error message below. I
cannot find the old password and do not know how to change it in the
system to allow it to succelfully authenticate again.
I'm running iis on a local network with an asp app. It tries to
connect to the sql database for the customer info.
Any help would be much appreciated. jho
error:microsoft OLE Provider for SQL Server (0x80040e4D) Login failed
for user 'sa'
Hi
You should not be using sa as a login for a web application, the account
will be in the connection string which could be in one of several locations
see http://msdn2.microsoft.com/en-us/library/aa302392.aspx for more.
John
"jho" <jhogan0101@.yahoo.com> wrote in message
news:2c959016-a208-44f3-a148-702eddd12032@.v29g2000hsf.googlegroups.com...
> Hello,
> I changed the sa password and now i get the error message below. I
> cannot find the old password and do not know how to change it in the
> system to allow it to succelfully authenticate again.
> I'm running iis on a local network with an asp app. It tries to
> connect to the sql database for the customer info.
> Any help would be much appreciated. jho
> error:microsoft OLE Provider for SQL Server (0x80040e4D) Login failed
> for user 'sa'
|||Hi
You should not be using sa as a login for a web application, the account
will be in the connection string which could be in one of several locations
see http://msdn2.microsoft.com/en-us/library/aa302392.aspx for more.
John
"jho" <jhogan0101@.yahoo.com> wrote in message
news:2c959016-a208-44f3-a148-702eddd12032@.v29g2000hsf.googlegroups.com...
> Hello,
> I changed the sa password and now i get the error message below. I
> cannot find the old password and do not know how to change it in the
> system to allow it to succelfully authenticate again.
> I'm running iis on a local network with an asp app. It tries to
> connect to the sql database for the customer info.
> Any help would be much appreciated. jho
> error:microsoft OLE Provider for SQL Server (0x80040e4D) Login failed
> for user 'sa'
|||Hi
You should not be using sa as a login for a web application, the account
will be in the connection string which could be in one of several locations
see http://msdn2.microsoft.com/en-us/library/aa302392.aspx for more.
John
"jho" <jhogan0101@.yahoo.com> wrote in message
news:2c959016-a208-44f3-a148-702eddd12032@.v29g2000hsf.googlegroups.com...
> Hello,
> I changed the sa password and now i get the error message below. I
> cannot find the old password and do not know how to change it in the
> system to allow it to succelfully authenticate again.
> I'm running iis on a local network with an asp app. It tries to
> connect to the sql database for the customer info.
> Any help would be much appreciated. jho
> error:microsoft OLE Provider for SQL Server (0x80040e4D) Login failed
> for user 'sa'
|||On Jan 13, 3:39Xpm, "John Bell" <jbellnewspo...@.hotmail.com> wrote:
> Hi
> You should not be using sa as a login for a web application, the account
> will be in the connection string which could be in one of several locations
> see Xhttp://msdn2.microsoft.com/en-us/library/aa302392.aspxfor more.
> John"jho" <jhogan0...@.yahoo.com> wrote in message
> news:2c959016-a208-44f3-a148-702eddd12032@.v29g2000hsf.googlegroups.com...
>
>
> - Show quoted text -
I am trying to change to nt authentication but it seems like it has no
effect when i change it in the "logins" section in sql enterprise
manager and iis. FYI i am a network guy who knows very little about
dbs' and sql but trying. I was initially trying to access the db from
a network pc when i changed or maybe enabled the sa password to gain
access for a mail merge. How do i undo this?
|||Hi
You would need to change the connection string in your ASP page to be
trusted authentication.
John
"jho" <jhogan0101@.yahoo.com> wrote in message
news:4b58f408-4194-4b19-bc8d-a60f46d5eb2e@.s8g2000prg.googlegroups.com...
On Jan 13, 3:39 pm, "John Bell" <jbellnewspo...@.hotmail.com> wrote:
> Hi
> You should not be using sa as a login for a web application, the account
> will be in the connection string which could be in one of several
> locations
> see http://msdn2.microsoft.com/en-us/library/aa302392.aspxfor more.
> John"jho" <jhogan0...@.yahoo.com> wrote in message
> news:2c959016-a208-44f3-a148-702eddd12032@.v29g2000hsf.googlegroups.com...
>
>
> - Show quoted text -
I am trying to change to nt authentication but it seems like it has no
effect when i change it in the "logins" section in sql enterprise
manager and iis. FYI i am a network guy who knows very little about
dbs' and sql but trying. I was initially trying to access the db from
a network pc when i changed or maybe enabled the sa password to gain
access for a mail merge. How do i undo this?
I changed the sa password and now i get the error message below. I
cannot find the old password and do not know how to change it in the
system to allow it to succelfully authenticate again.
I'm running iis on a local network with an asp app. It tries to
connect to the sql database for the customer info.
Any help would be much appreciated. jho
error:microsoft OLE Provider for SQL Server (0x80040e4D) Login failed
for user 'sa'
Hi
You should not be using sa as a login for a web application, the account
will be in the connection string which could be in one of several locations
see http://msdn2.microsoft.com/en-us/library/aa302392.aspx for more.
John
"jho" <jhogan0101@.yahoo.com> wrote in message
news:2c959016-a208-44f3-a148-702eddd12032@.v29g2000hsf.googlegroups.com...
> Hello,
> I changed the sa password and now i get the error message below. I
> cannot find the old password and do not know how to change it in the
> system to allow it to succelfully authenticate again.
> I'm running iis on a local network with an asp app. It tries to
> connect to the sql database for the customer info.
> Any help would be much appreciated. jho
> error:microsoft OLE Provider for SQL Server (0x80040e4D) Login failed
> for user 'sa'
|||Hi
You should not be using sa as a login for a web application, the account
will be in the connection string which could be in one of several locations
see http://msdn2.microsoft.com/en-us/library/aa302392.aspx for more.
John
"jho" <jhogan0101@.yahoo.com> wrote in message
news:2c959016-a208-44f3-a148-702eddd12032@.v29g2000hsf.googlegroups.com...
> Hello,
> I changed the sa password and now i get the error message below. I
> cannot find the old password and do not know how to change it in the
> system to allow it to succelfully authenticate again.
> I'm running iis on a local network with an asp app. It tries to
> connect to the sql database for the customer info.
> Any help would be much appreciated. jho
> error:microsoft OLE Provider for SQL Server (0x80040e4D) Login failed
> for user 'sa'
|||Hi
You should not be using sa as a login for a web application, the account
will be in the connection string which could be in one of several locations
see http://msdn2.microsoft.com/en-us/library/aa302392.aspx for more.
John
"jho" <jhogan0101@.yahoo.com> wrote in message
news:2c959016-a208-44f3-a148-702eddd12032@.v29g2000hsf.googlegroups.com...
> Hello,
> I changed the sa password and now i get the error message below. I
> cannot find the old password and do not know how to change it in the
> system to allow it to succelfully authenticate again.
> I'm running iis on a local network with an asp app. It tries to
> connect to the sql database for the customer info.
> Any help would be much appreciated. jho
> error:microsoft OLE Provider for SQL Server (0x80040e4D) Login failed
> for user 'sa'
|||On Jan 13, 3:39Xpm, "John Bell" <jbellnewspo...@.hotmail.com> wrote:
> Hi
> You should not be using sa as a login for a web application, the account
> will be in the connection string which could be in one of several locations
> see Xhttp://msdn2.microsoft.com/en-us/library/aa302392.aspxfor more.
> John"jho" <jhogan0...@.yahoo.com> wrote in message
> news:2c959016-a208-44f3-a148-702eddd12032@.v29g2000hsf.googlegroups.com...
>
>
> - Show quoted text -
I am trying to change to nt authentication but it seems like it has no
effect when i change it in the "logins" section in sql enterprise
manager and iis. FYI i am a network guy who knows very little about
dbs' and sql but trying. I was initially trying to access the db from
a network pc when i changed or maybe enabled the sa password to gain
access for a mail merge. How do i undo this?
|||Hi
You would need to change the connection string in your ASP page to be
trusted authentication.
John
"jho" <jhogan0101@.yahoo.com> wrote in message
news:4b58f408-4194-4b19-bc8d-a60f46d5eb2e@.s8g2000prg.googlegroups.com...
On Jan 13, 3:39 pm, "John Bell" <jbellnewspo...@.hotmail.com> wrote:
> Hi
> You should not be using sa as a login for a web application, the account
> will be in the connection string which could be in one of several
> locations
> see http://msdn2.microsoft.com/en-us/library/aa302392.aspxfor more.
> John"jho" <jhogan0...@.yahoo.com> wrote in message
> news:2c959016-a208-44f3-a148-702eddd12032@.v29g2000hsf.googlegroups.com...
>
>
> - Show quoted text -
I am trying to change to nt authentication but it seems like it has no
effect when i change it in the "logins" section in sql enterprise
manager and iis. FYI i am a network guy who knows very little about
dbs' and sql but trying. I was initially trying to access the db from
a network pc when i changed or maybe enabled the sa password to gain
access for a mail merge. How do i undo this?
ASP.net app error after changing sa password
Hello,
I changed the sa password and now i get the error message below. I
cannot find the old password and do not know how to change it in the
system to allow it to succelfully authenticate again.
I'm running iis on a local network with an asp app. It tries to
connect to the sql database for the customer info.
Any help would be much appreciated. jho
error:microsoft OLE Provider for SQL Server (0x80040e4D) Login failed
for user 'sa'Hi
You should not be using sa as a login for a web application, the account
will be in the connection string which could be in one of several locations
see http://msdn2.microsoft.com/en-us/library/aa302392.aspx for more.
John
"jho" <jhogan0101@.yahoo.com> wrote in message
news:2c959016-a208-44f3-a148-702eddd12032@.v29g2000hsf.googlegroups.com...
> Hello,
> I changed the sa password and now i get the error message below. I
> cannot find the old password and do not know how to change it in the
> system to allow it to succelfully authenticate again.
> I'm running iis on a local network with an asp app. It tries to
> connect to the sql database for the customer info.
> Any help would be much appreciated. jho
> error:microsoft OLE Provider for SQL Server (0x80040e4D) Login failed
> for user 'sa'|||Hi
You should not be using sa as a login for a web application, the account
will be in the connection string which could be in one of several locations
see http://msdn2.microsoft.com/en-us/library/aa302392.aspx for more.
John
"jho" <jhogan0101@.yahoo.com> wrote in message
news:2c959016-a208-44f3-a148-702eddd12032@.v29g2000hsf.googlegroups.com...
> Hello,
> I changed the sa password and now i get the error message below. I
> cannot find the old password and do not know how to change it in the
> system to allow it to succelfully authenticate again.
> I'm running iis on a local network with an asp app. It tries to
> connect to the sql database for the customer info.
> Any help would be much appreciated. jho
> error:microsoft OLE Provider for SQL Server (0x80040e4D) Login failed
> for user 'sa'|||Hi
You should not be using sa as a login for a web application, the account
will be in the connection string which could be in one of several locations
see http://msdn2.microsoft.com/en-us/library/aa302392.aspx for more.
John
"jho" <jhogan0101@.yahoo.com> wrote in message
news:2c959016-a208-44f3-a148-702eddd12032@.v29g2000hsf.googlegroups.com...
> Hello,
> I changed the sa password and now i get the error message below. I
> cannot find the old password and do not know how to change it in the
> system to allow it to succelfully authenticate again.
> I'm running iis on a local network with an asp app. It tries to
> connect to the sql database for the customer info.
> Any help would be much appreciated. jho
> error:microsoft OLE Provider for SQL Server (0x80040e4D) Login failed
> for user 'sa'|||On Jan 13, 3:39=A0pm, "John Bell" <jbellnewspo...@.hotmail.com> wrote:
> Hi
> You should not be using sa as a login for a web application, the account
> will be in the connection string which could be in one of several location=s
> see =A0http://msdn2.microsoft.com/en-us/library/aa302392.aspxfor more.
> John"jho" <jhogan0...@.yahoo.com> wrote in message
> news:2c959016-a208-44f3-a148-702eddd12032@.v29g2000hsf.googlegroups.com...
>
> > Hello,
> > I changed the sa password and now i get the error message below. I
> > cannot find the old password and do not know how to change it in the
> > system to allow it to succelfully authenticate again.
> > I'm running iis on a local network with an asp app. It tries to
> > connect to the sql database for the customer info.
> > Any help would be much appreciated. jho
> > error:microsoft OLE Provider for SQL Server (0x80040e4D) Login failed
> > for user 'sa'- Hide quoted text -
> - Show quoted text -
I am trying to change to nt authentication but it seems like it has no
effect when i change it in the "logins" section in sql enterprise
manager and iis. FYI i am a network guy who knows very little about
dbs' and sql but trying. I was initially trying to access the db from
a network pc when i changed or maybe enabled the sa password to gain
access for a mail merge. How do i undo this?|||Hi
You would need to change the connection string in your ASP page to be
trusted authentication.
John
"jho" <jhogan0101@.yahoo.com> wrote in message
news:4b58f408-4194-4b19-bc8d-a60f46d5eb2e@.s8g2000prg.googlegroups.com...
On Jan 13, 3:39 pm, "John Bell" <jbellnewspo...@.hotmail.com> wrote:
> Hi
> You should not be using sa as a login for a web application, the account
> will be in the connection string which could be in one of several
> locations
> see http://msdn2.microsoft.com/en-us/library/aa302392.aspxfor more.
> John"jho" <jhogan0...@.yahoo.com> wrote in message
> news:2c959016-a208-44f3-a148-702eddd12032@.v29g2000hsf.googlegroups.com...
>
> > Hello,
> > I changed the sa password and now i get the error message below. I
> > cannot find the old password and do not know how to change it in the
> > system to allow it to succelfully authenticate again.
> > I'm running iis on a local network with an asp app. It tries to
> > connect to the sql database for the customer info.
> > Any help would be much appreciated. jho
> > error:microsoft OLE Provider for SQL Server (0x80040e4D) Login failed
> > for user 'sa'- Hide quoted text -
> - Show quoted text -
I am trying to change to nt authentication but it seems like it has no
effect when i change it in the "logins" section in sql enterprise
manager and iis. FYI i am a network guy who knows very little about
dbs' and sql but trying. I was initially trying to access the db from
a network pc when i changed or maybe enabled the sa password to gain
access for a mail merge. How do i undo this?
I changed the sa password and now i get the error message below. I
cannot find the old password and do not know how to change it in the
system to allow it to succelfully authenticate again.
I'm running iis on a local network with an asp app. It tries to
connect to the sql database for the customer info.
Any help would be much appreciated. jho
error:microsoft OLE Provider for SQL Server (0x80040e4D) Login failed
for user 'sa'Hi
You should not be using sa as a login for a web application, the account
will be in the connection string which could be in one of several locations
see http://msdn2.microsoft.com/en-us/library/aa302392.aspx for more.
John
"jho" <jhogan0101@.yahoo.com> wrote in message
news:2c959016-a208-44f3-a148-702eddd12032@.v29g2000hsf.googlegroups.com...
> Hello,
> I changed the sa password and now i get the error message below. I
> cannot find the old password and do not know how to change it in the
> system to allow it to succelfully authenticate again.
> I'm running iis on a local network with an asp app. It tries to
> connect to the sql database for the customer info.
> Any help would be much appreciated. jho
> error:microsoft OLE Provider for SQL Server (0x80040e4D) Login failed
> for user 'sa'|||Hi
You should not be using sa as a login for a web application, the account
will be in the connection string which could be in one of several locations
see http://msdn2.microsoft.com/en-us/library/aa302392.aspx for more.
John
"jho" <jhogan0101@.yahoo.com> wrote in message
news:2c959016-a208-44f3-a148-702eddd12032@.v29g2000hsf.googlegroups.com...
> Hello,
> I changed the sa password and now i get the error message below. I
> cannot find the old password and do not know how to change it in the
> system to allow it to succelfully authenticate again.
> I'm running iis on a local network with an asp app. It tries to
> connect to the sql database for the customer info.
> Any help would be much appreciated. jho
> error:microsoft OLE Provider for SQL Server (0x80040e4D) Login failed
> for user 'sa'|||Hi
You should not be using sa as a login for a web application, the account
will be in the connection string which could be in one of several locations
see http://msdn2.microsoft.com/en-us/library/aa302392.aspx for more.
John
"jho" <jhogan0101@.yahoo.com> wrote in message
news:2c959016-a208-44f3-a148-702eddd12032@.v29g2000hsf.googlegroups.com...
> Hello,
> I changed the sa password and now i get the error message below. I
> cannot find the old password and do not know how to change it in the
> system to allow it to succelfully authenticate again.
> I'm running iis on a local network with an asp app. It tries to
> connect to the sql database for the customer info.
> Any help would be much appreciated. jho
> error:microsoft OLE Provider for SQL Server (0x80040e4D) Login failed
> for user 'sa'|||On Jan 13, 3:39=A0pm, "John Bell" <jbellnewspo...@.hotmail.com> wrote:
> Hi
> You should not be using sa as a login for a web application, the account
> will be in the connection string which could be in one of several location=s
> see =A0http://msdn2.microsoft.com/en-us/library/aa302392.aspxfor more.
> John"jho" <jhogan0...@.yahoo.com> wrote in message
> news:2c959016-a208-44f3-a148-702eddd12032@.v29g2000hsf.googlegroups.com...
>
> > Hello,
> > I changed the sa password and now i get the error message below. I
> > cannot find the old password and do not know how to change it in the
> > system to allow it to succelfully authenticate again.
> > I'm running iis on a local network with an asp app. It tries to
> > connect to the sql database for the customer info.
> > Any help would be much appreciated. jho
> > error:microsoft OLE Provider for SQL Server (0x80040e4D) Login failed
> > for user 'sa'- Hide quoted text -
> - Show quoted text -
I am trying to change to nt authentication but it seems like it has no
effect when i change it in the "logins" section in sql enterprise
manager and iis. FYI i am a network guy who knows very little about
dbs' and sql but trying. I was initially trying to access the db from
a network pc when i changed or maybe enabled the sa password to gain
access for a mail merge. How do i undo this?|||Hi
You would need to change the connection string in your ASP page to be
trusted authentication.
John
"jho" <jhogan0101@.yahoo.com> wrote in message
news:4b58f408-4194-4b19-bc8d-a60f46d5eb2e@.s8g2000prg.googlegroups.com...
On Jan 13, 3:39 pm, "John Bell" <jbellnewspo...@.hotmail.com> wrote:
> Hi
> You should not be using sa as a login for a web application, the account
> will be in the connection string which could be in one of several
> locations
> see http://msdn2.microsoft.com/en-us/library/aa302392.aspxfor more.
> John"jho" <jhogan0...@.yahoo.com> wrote in message
> news:2c959016-a208-44f3-a148-702eddd12032@.v29g2000hsf.googlegroups.com...
>
> > Hello,
> > I changed the sa password and now i get the error message below. I
> > cannot find the old password and do not know how to change it in the
> > system to allow it to succelfully authenticate again.
> > I'm running iis on a local network with an asp app. It tries to
> > connect to the sql database for the customer info.
> > Any help would be much appreciated. jho
> > error:microsoft OLE Provider for SQL Server (0x80040e4D) Login failed
> > for user 'sa'- Hide quoted text -
> - Show quoted text -
I am trying to change to nt authentication but it seems like it has no
effect when i change it in the "logins" section in sql enterprise
manager and iis. FYI i am a network guy who knows very little about
dbs' and sql but trying. I was initially trying to access the db from
a network pc when i changed or maybe enabled the sa password to gain
access for a mail merge. How do i undo this?
Subscribe to:
Posts (Atom)