Re: INSERT an UPDATE permission denied on object

• Previous message: Hal Heinrich: "How to determine EXEC permission to an extended stored procedure?"
• In reply to: Dan Guzman: "Re: INSERT an UPDATE permission denied on object"
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]

Date: Mon, 16 May 2005 11:25:56 -0700

Hi,

The problem was solved with the revoke.

Thanks Dan and Janes for you help.

"Dan Guzman" wrote:

> As Jens mentioned, an explicit DENY takes precedence over other object
> permissions. Check the permissions on the table with sp_helprotect.
>
> USE IX
> EXEC sp_helprotect 'dbo.TBILL'
>
> If DENY permissions are listed, you can remove these with REVOKE so that the
> user's db_owner role permissions are used. For example:
>
> USE IX
> REVOKE ALL ON dbo.TBILL FROM SomeUser
>
> > I don´t understand why just this db.
>
> Aside from server roles, security in each database is managed independently
> of other databases. Each has it's own set of allowed users, roles, role
> members and object permissions.
>
> --
> Hope this helps.
>
> Dan Guzman
> SQL Server MVP
>
> "Leo Quezada" <LeoQuezada@discussions.microsoft.com> wrote in message
> news:E854BA95-1202-4799-A9CD-0B6437583A42@microsoft.com...
> > 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
> >>
> >>
> >>
>
>
>

• Previous message: Hal Heinrich: "How to determine EXEC permission to an extended stored procedure?"
• In reply to: Dan Guzman: "Re: INSERT an UPDATE permission denied on object"
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]