Cannot find the object "Table_Name" because it does not exist or you do not have permissions.

Question

Cannot find the object "Table_Name" because it does not exist or you do not have permissions.

rpetit1230

Old Hand

Points: 318
More actions
May 5, 2015 at 1:53 pm

#303600

I'm trying to run an Insert on tables using a User Login but I keep getting the error above. I ran the insert using my own credentials and it worked. The User LOGIN in question has read & write permission to the database. Anyone run into this problem?

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Alan Burstein SSC Guru Points: 61136 More actions · Answer 1

rpetit1230 (5/5/2015)
I'm trying to run an Insert on tables using a User Login but I keep getting the error above. I ran the insert using my own credentials and it worked. The User LOGIN in question has read & write permission to the database. Anyone run into this problem?

What do you mean by "The User LOGIN in question has read & write permission"? I'm assuming that mean that if you go to Your Server > Security > Logins > The User that they are mapped the DB in question and have db_datareader and db_datawriter rights. If they do then check the permissions on the table... Can they insert into other tables in that particular DB?

Those are my initial thoughts.

P.S. forgive me if I got the above role names wrong (you know the roles I'm talking about)... No access to a 2012 instance at the moment.

"I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

-- Itzik Ben-Gan 2001

SQLBill SSC Guru Points: 51440 More actions · Answer 2

My thoughts....if the user has permissions to connect to the database and has db_datareader/db_datawriter; the next things I would check are:

1. the permissions on the table itself. have they been denied the right to read/write on that table

2. is there a trigger that is affecting permissions? maybe a trigger is trying to write to another table that the user doesn't have permissions on.

-SQLBill

rpetit1230 Old Hand Points: 318 More actions · Answer 3

Thanks for the help. But I figured it out. There was a set identity On & Off statements in the script so you need ddl_admin rights added to the login. @alan B I mean LOGIN but it's used as a general user account by DEV.

Eirikur Eiriksson SSC Guru Points: 182882 More actions · Answer 4

rpetit1230 (5/5/2015)
I'm trying to run an Insert on tables using a User Login but I keep getting the error above. I ran the insert using my own credentials and it worked. The User LOGIN in question has read & write permission to the database. Anyone run into this problem?

Quick questions, is the table name schema qualified in the insert script? Can the user select from the table?

😎

alexekoz Newbie Points: 1 More actions · Answer 5

If u have set identity_insert, must have permission to alter table or have execute as owner