Re: Create table rights
Date: Thu, 1 Sep 2005 10:16:10 -0700
I didnt realize a deny to a user of a group that has right overrides a
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.
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 .
- 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. ...
- 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 ...
- 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. ...
- 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 ...
- 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 ...