Re: INSERT an UPDATE permission denied on object

From: Leo Quezada (LeoQuezada_at_discussions.microsoft.com)
Date: 05/13/05

  • Next message: Michelle: "Retrieving ALL Object Privs for ALL Users in ALL Databases" 
    Date: Fri, 13 May 2005 13:26:07 -0700

    Hi Jens,

    The exception is:
    Server: Msg 229, Level 14, State 5, Line 1
    INSERT permission denied on object 'TBILL', database 'IX', owner 'dbo'.

    The only way to do insert or update in this db is that i assign the role
    server 'sa' to the NT Login. I don´t understand why just this db.

    Regards,

    Leo

    "Jens Süßmeyer" wrote:

    > 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
    >
    >
    >

  • Next message: Michelle: "Retrieving ALL Object Privs for ALL Users in ALL Databases"

    Relevant Pages

    • Re: not creating tables as dbo anymore ?
      ... Database Owner (dbo) ... existing user ID in the database specified by database_name. ... with the login of the current connection. ...
      (microsoft.public.sqlserver.security)
    • Re: Change UDF Owner
      ... Does it exist in the master database? ... Users can be put in the dbo role, but dbo will still own objects ... concept of 'schema' as 'owner' rather than just schema as DDL is exploited ... to the appropriate Fixed Server Roles or whatever is applicable. ...
      (microsoft.public.sqlserver.security)
    • Re: Change UDF Owner
      ... system_function_schema -especially in the master database. ... Most good judgment comes from experience. ... dbo is in the context of a database, and can be the schema owner for the ... Users can be put in the dbo role, ...
      (microsoft.public.sqlserver.security)
    • Re: conflicting object names in sql server 2000
      ... On the local database server when it does the select * from ... > michael.xxx Note that michael is the owner of the database. ... it will see if there is one owned by dbo. ...
      (microsoft.public.sqlserver.server)
    • Re: Confused about dbo
      ... Jasper Smith (SQL Server MVP) ... > database within a SQL Server instance. ... > There are several ways you could have the username dbo. ... > the true owner of the database. ...
      (microsoft.public.sqlserver.security)