?
Solved

Permissions issue

Posted on 2009-07-13
6
Medium Priority
?
307 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

 
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

Optimize your web performance

What's in the eBook?
- Full list of reasons for poor performance
- Ultimate measures to speed things up
- Primary web monitoring types
- KPIs you should be monitoring in order to increase your ROI

Question has a verified solution.

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

International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
I have a large data set and a SSIS package. How can I load this file in multi threading?
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Suggested Courses

771 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