Solved

Permissions issue

Posted on 2009-07-13
6
302 Views
Last Modified: 2013-11-30
Hi:

I am running the following sql query:

update dbo.tblClientid SET dbo.tblClientid.ISLOGICALLYDELETED = 1
FROM dbo.tblClientid
    INNER JOIN Auxiliary.di.TMP_CLIENTIDKEYS
    ON (Auxiliary.di.TMP_CLIENTIDKEYS.ClientIdKey = dbo.tblClientid.ClientIdKey);

I am getting the following error::
The UPDATE permission was denied on the column 'ClientIDKey' of the object 'tblClientId',
database 'ProdReporting',
schema 'dbo'


I have permissions to update the column ISLOGICALLYDELETED. I can't undersatnd why I am getting this error 'ClientIDKey'  when I am not updating the column.
0
Comment
Question by:raGadiraju
  • 3
  • 2
6 Comments
 
LVL 29

Expert Comment

by:QPR
ID: 24843872
any update triggers on the table you are trying to update?
0
 

Author Comment

by:raGadiraju
ID: 24843894
NO. Its a plain update statement.
0
 
LVL 29

Expert Comment

by:QPR
ID: 24844352
plain update statement?
Regardless of how plain or fancy an update statement is an update trigger on a table will still fire unless disabled.
Try scripting out the table structure and looking at it, any constraints, defaults, triggers?
0
NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

 
LVL 7

Expert Comment

by:wilje
ID: 24846000
Try removing the table reference from the column specification:
UPDATE dbo.tblClientid SET ISLOGICALLYDELETED = 1 ...
0
 

Author Comment

by:raGadiraju
ID: 24855719
Guys I figured out what the issue was. This update was not a trigger nor it was due the table reference. The update was part of a stored proc and I was calling the db using linked server. It so happened that I was a readonly user on the other server.

 I sincerely appreciate your help in this regard.
0
 

Accepted Solution

by:
raGadiraju earned 0 total points
ID: 24855724
Guys I figured out what the issue was. This update was not a trigger nor it was due the table reference. The update was part of a stored proc and I was calling the db using linked server. It so happened that I was a readonly user on the other server.

 I sincerely appreciate your help in this regard.
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SQL query for highest sequence 4 59
IF SQL Query 12 27
SQL Select Query help 1 34
the way to learn Microsoft BI 13 44
JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

735 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question