Re: Confused about ListUserColumnPermissions

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

From: Sue Hoegemeier <Sue_H@nomail.please>
Date: Tue, 05 Nov 2002 06:50:47 -0700

Don't know of something that just returns an and every
column denied so you may have to write your own. Other means
of obtaining column level permissions would include querying
the view information_schema.column_privileges and executing
the stored procedure sp_column_privileges. You can also get
information from the permissions function and
sp_helprotect.

-Sue

On Mon, 04 Nov 2002 22:21:22 -0800, Garrett Fitzgerald
<gfitzger@nyx.net> wrote:

>Sue Hoegemeier <Sue_H@nomail.please> wrote in
>news:53besusted6oq0h0h6r80da878ujbg52d7@4ax.com:
>> Yes...that's how it will work. ListUserColumnPermissions
>> enumerates through explicit permissions only.
>
>Well, what I'm trying to do here is disable any fields on the front end
>that aren't allowed to be updated on the back end. Is there a call which
>_will_ tell me everything that is DENYed?

Relevant Pages

  • Re: Is there cascading permission?
    ... The principal is basically that permissions on indirectly referenced objects are not needed as long as the objects involved have the same owner. ... if a user has permission to execute a stored procedure which in> turn ... > consumes objects that the same user does not have explicit permissions ...
    (microsoft.public.sqlserver.security)
  • Re: Mirroring Novell permissions on NTFS partition
    ... would love to duplicate the Novell permissions on W2K that prevent users ... if a group is assigned permissions ... > all previous folders, allowing them a clear path to the ... > folder where they have explicit permissions. ...
    (microsoft.public.win2000.security)
  • Re: Groups Permissions; creating a new group & adding full access does not appear to work
    ... And you are right, they get explicit permissions, and you hit upon the ... "sum of permissions" as members of other groups. ... When a User is logged on, changing explicit permissions happen right ...
    (microsoft.public.win2000.active_directory)
  • Re: Inherit from parent permissions
    ... I am a little confused as you say they are already inheriting permissions? ... You may want to try the xcalcs tool to add explicit permissions to those ... folders if you need to just be sure to use the /E switch for edit. ...
    (microsoft.public.win2000.security)
  • Re: Copy a file with permissions
    ... See the link below on how to use xcopy /o to do such. ... You can however change inherited permissions to ... explicit permissions by going into the security advanced page where you can remove ...
    (microsoft.public.win2000.group_policy)