DB owner rights confusion

Hi all,
sa is the owner of all table objects in one of my database. I grant users
db_reader and db_writer to the database assuming that users will have all
permission on all tables including INSERT. For some reasons, user can't not
execute INSERT on one table in the database unless I give them db_owner
previllege. Any clue on this?
Thanks a lot in advance.
Han,I will be asking the following questions
1) is there a trigger on this table
2) might also want to try running sp_changeobjectowner (just to be on the
safe side)
I think that point 1 is most likely though.
HTH
"Han" <Han@.discussions.microsoft.com> wrote in message
news:5E0AB82F-E5BE-4923-95C6-27A3EA22E1F5@.microsoft.com...
> Hi all,
> sa is the owner of all table objects in one of my database. I grant users
> db_reader and db_writer to the database assuming that users will have all
> permission on all tables including INSERT. For some reasons, user can't
not
> execute INSERT on one table in the database unless I give them db_owner
> previllege. Any clue on this?
> Thanks a lot in advance.
> Han,|||Check to see if there is an explicit DENY on the table. DENY takes
precedence over GRANT.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Han" <Han@.discussions.microsoft.com> wrote in message
news:5E0AB82F-E5BE-4923-95C6-27A3EA22E1F5@.microsoft.com...
> Hi all,
> sa is the owner of all table objects in one of my database. I grant users
> db_reader and db_writer to the database assuming that users will have all
> permission on all tables including INSERT. For some reasons, user can't
> not
> execute INSERT on one table in the database unless I give them db_owner
> previllege. Any clue on this?
> Thanks a lot in advance.
> Han,