Re: Create table rights

From: jaylou (jaylou_at_discussions.microsoft.com)
Date: 09/01/05 

Date: Thu, 1 Sep 2005 10:16:10 -0700

Thanks,
I didnt realize a deny to a user of a group that has right overrides a
grant...

I ran sp_helpprotect and it returned the following:
as you can see this user, who is not part of any group has grant for
creating a table, but he still can't create one.

Very frustrating....
Thanks again,
Joe

Owner Object Grantee Grantor ProtectType Action Column
----- ------ -------------- ------- ----------- ------------------ ------
. . website dbo Grant Backup Database .
. . website dbo Grant Backup Transaction .
. . website dbo Grant Create Default .
. . website dbo Grant Create Function .
. . website dbo Grant Create Procedure .
. . website dbo Grant Create Rule .
. . website dbo Grant Create Table .
. . website dbo Grant Create View .

Relevant Pages

  • Re: Access Token with conflicting SIDs
    ... Basically deny overrides grant. ... If you have inheritance going on this gets a little trickier. ... An inherited deny can be overridden by an inherited grant that is applied lower in the hierarchy or by an explicit grant. ...
    (microsoft.public.platformsdk.security)
  • Re: Laydee-boy
    ... Grant wrote: ... Mr Christopher Stevens ... didnt you carry out threats made agaisnt him? ... I guess wondering is not something thats very familiar to someone as ...
    (uk.local.southwest)
  • Re: amended tax return
    ... >>i didnt use anything about my grant on my taxs all we used was my husbands ... >> w-2 and that is it. ... She didnt even mention me going to school. ... info on Pell grant was received. ...
    (misc.taxes)
  • Re: Flipping nut monkeys
    ... ripped off, not good practice i grant you, but he's not parted with any ... money or had any bits fitted that he didnt require, only the tyre which he ...
    (uk.rec.cars.maintenance)
  • Re: do allowed perrmisions override denyed permissions?
    ... I thought deny access was more of a useful way to do things *TO* them! ... only grant permissions. ... | Explicit Grant ACEs for Object | ... to sort that out is with hierarchical precedence of the inheritance ...
    (microsoft.public.windows.server.security)