Re: Confused about ListUserColumnPermissions

From: Sue Hoegemeier (Sue_H@nomail.please)
Date: 11/05/02 

From: Sue Hoegemeier <Sue_H@nomail.please>
Date: Mon, 04 Nov 2002 19:30:36 -0700

Yes...that's how it will work. ListUserColumnPermissions
enumerates through explicit permissions only.

-Sue

On Mon, 04 Nov 2002 13:18:33 -0800, Garrett Fitzgerald
<gfitzger@nyx.net> wrote:

>I just ran ListUserColumnPermissions against one of my tables. The
>specified user had DENY on one column, and it belonged to a role which had
>DENY on a different column. However, ListPrivilegeColumns only showed me
>the permission belonging to the user. This seems to make it pretty darned
>near useless for my purposes. I found that I could run LUCP against the
>role, instead of the user, but then I have to add code to figure out which
>role -- or roles -- the user is in. Not ideal.
>
>I'm running SQL Server 2000, if that's relevant to the question. Thanks!

Relevant Pages

  • Re: Viewing mail
    ... Jan I not disputing your claim, but the explicit permissions for deny are ... > Plz note that this will not work you you are running exchange 2003. ... > since the explicit permissions for domain admins has been set to deny in ...
    (microsoft.public.exchange2000.admin)
  • Re: deny a users ability to SELECT
    ... If so, deny won't work. ... This posting is provided "AS IS" with no warranties, ... This gives the user access to SELECT from my tables. ... 'SELECT' option in the 'Explicit permissions for ' ...
    (microsoft.public.sqlserver.security)
  • Confused about ListUserColumnPermissions
    ... I just ran ListUserColumnPermissions against one of my tables. ... specified user had DENY on one column, and it belonged to a role which had ... DENY on a different column. ... the permission belonging to the user. ...
    (microsoft.public.sqlserver.security)
  • Re: deny a users ability to SELECT
    ... I can only use deny with Windows authenticated users? ... Administrator on the box? ... This gives the user access to SELECT from my tables. ... the 'SELECT' option in the 'Explicit permissions for ' ...
    (microsoft.public.sqlserver.security)
  • Re: Confused about ListUserColumnPermissions
    ... Sue Hoegemeier wrote in ... ListUserColumnPermissions ... > enumerates through explicit permissions only. ...
    (microsoft.public.sqlserver.security)