Solved

Permissions issue

Posted on 2009-07-13
6
300 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
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 
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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

Suggested Solutions

In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Viewers will learn how the fundamental information of how to create a table.

773 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