Re: INSERT an UPDATE permission denied on object

From: Jens Süßmeyer (Jens_at_Remove_this_For_Contacting.sqlserver2005.de)
Date: 05/13/05 

Date: Fri, 13 May 2005 20:53:15 +0200

What exception message do you get ?

Even if you are in the role of dbowner you could been blocked for some
reason with a deny rule. Perhaps someone intercepts the security system ?
Tell us what exeption you get.

HTH, Jens Suessmeyer. 

---
http://www.sqlserver2005.de
---
"Leo Quezada" <LeoQuezada@discussions.microsoft.com> schrieb im Newsbeitrag 
news:D04FA683-8A20-4918-82E9-E0286249B17A@microsoft.com...
> Hi,
>
> I have a problem when i try to insert or update in a particular database 
> in
> my sql2000 server,  when i use a NT login that have the role dbowner i 
> can´t
> but if i use a SQL Login is ok. In the others databases i dont have 
> problem.
>
> This worked until days ago, today not.
>
> thanks for yoo help

Relevant Pages

  • RE: Rename table from stored procedure
    ... dbOwner] and that can change objects in the current database only. ... Hermilson ...
    (microsoft.public.sqlserver.programming)
  • Basic Server Roles (security) question
    ... database on my SQL 2000 SP3 server (so DBOWNER is ok with me). ... But I also need them to be able to schedule a job against that database ...
    (microsoft.public.sqlserver.security)
  • Re: database chain issue; DBO loginname change?
    ... i was using sp_dbchangedbowner on the wrong database. ... Database B was consistant in this manner. ... i believe that the dbowner and the dbo-loginname should equate. ... >> I see one inconsistancy, ...
    (microsoft.public.sqlserver.security)