Permission error when trying to INSERT data

I have a user trying to insert a record into a table on my SQL 2000 server.
When she tries to do the insert she gets a message "Insert permissions denie
d
on object 'mytable', database 'mydatabase', owner 'dbo'". This user is a
member of an Active Directory group on my network. The AD group has rights t
o
the database on my SQL Server. The AD group has select, insert, update and
delete rights to the table in question. Yet even after all of this she is
still unable to insert records into this table.
What could be causing my problem? We recently changed the service log on
user for the MSSQLServer logon. I wouldn't expect this to make any differenc
e
in her ability to insert a record into this table. Am I wrong?
Any help would be greatly appreciated.Hi,
By any chance some one DENY INSERT to this user for this table.
Thanks
Hari
SQL Server MVP
"Snowmizer" <Snowmizer@.discussions.microsoft.com> wrote in message
news:104EB25F-C2F7-46A3-8A5B-7B9AC61A6F16@.microsoft.com...
>I have a user trying to insert a record into a table on my SQL 2000 server.
> When she tries to do the insert she gets a message "Insert permissions
> denied
> on object 'mytable', database 'mydatabase', owner 'dbo'". This user is a
> member of an Active Directory group on my network. The AD group has rights
> to
> the database on my SQL Server. The AD group has select, insert, update and
> delete rights to the table in question. Yet even after all of this she is
> still unable to insert records into this table.
> What could be causing my problem? We recently changed the service log on
> user for the MSSQLServer logon. I wouldn't expect this to make any
> difference
> in her ability to insert a record into this table. Am I wrong?
> Any help would be greatly appreciated.
>