October 13, 2003 at 4:17 pm
On some tables a username which has owner permissions can enter data into the table and in some cases they can not. I've given the username permissions to Select, Insert, Update, and Delete to no avail. Why and what do I need to do to correct this situation. Any help is appreciated.
October 14, 2003 at 1:51 am
hi,
are there any triggers on the table ?
Paul
October 14, 2003 at 3:31 pm
Just a thought but could they not be logging in as what you expect.
Turn on sql profiler and what when they hit the table. It will tell you how they are logging in.
October 15, 2003 at 7:30 am
The owner of the table normally bypasses all permissions checks, just like dbo does (except dbo does for all objects). I agree with sqlSushi... stand up Profiler and see exactly what the user is doing.
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
K. Brian Kelley
@kbriankelley
October 16, 2003 at 8:49 am
I'll use profiler to see what is occuring. After reading my narrative I have decided it wasn't clear that I'm referring to separate tables. One where I can load data in the table and one where I can't.
October 21, 2003 at 9:11 am
You have two separate tables and in one you can load data and the other you can't.
You'll need to check permissions on these tables. Check to ensure the username doing the loading has the appropriate permissions (INSERT or UPDATE) granted on the table. Also verify the username has no DENY permissions set... this would include being made a member of a role that would be denied the ability to INSERT or UPDATE as the case may be.
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
K. Brian Kelley
@kbriankelley
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply