Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-05-01 : 13:41:48
|
Vikram writes "Hi,
This question is regarding SQL 7 fixed database Roles. I created a new login, and in the "SQL server Login properties", under the tab "Database Access", I chose a Database, and permitted the following roles for this new user - public (doesn't let me turn this off), db_datawriter.
According to "Professional SQL Server 7.0 Programming" book by Robert Vieira (published by WROX), db_datawriter can issue INSERT, UPDATE, and DELETE statements on all tables in the DB. This information can be found in ch-23, called Security (pg 818 for specific reference).
I am using vbscript (asp) and I am able to INSERT from my webpage, but I get the following error when I try to UPDATE -
------------------------------------------------------------
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E09)
[Microsoft][ODBC SQL Server Driver][SQL Server]SELECT permission denied on object 'BillingData', database 'gsiwebhosting_billingdata', owner 'dbo'.
DBTEST.asp, line 12
Browser Type:
Mozilla/4.0 (compatible; MSIE 5.5; Windows NT 5.0)
---------------------------------------------------------------
In my asp vbscript test file I am not doing any selects. Infact, LINE 12 in the error above is just the line where I execute my SQL. My SQL statement simply reads :
"UPDATE table SET ExpireMonth='10' WHERE CustomerID=1101"
I'm confused because in the error, it keeps mentioning select, and I'm not doing any select.
If I am able to Insert, I should be able to Update too. This thing has me completely stumped and I cannot find any information on this anywhere. Your help is appreciated." |
|
|
|
|
|
|
|
db_datawriter role doesn't let me update