Re: Setting Table Permissions?

From: Andrew J. Kelly (sqlmvpnooospam_at_shadhawk.com)
Date: 12/23/03 

Date: Tue, 23 Dec 2003 15:56:27 -0500

Checked - Granted
X'd - Denied
Empty - Revoked

By default a user has no rights to an object unless they are dbo or in a
role that has rights. So unless you add them to a role with permissions you
only need to grant them access to the objects you want them to have. 

-- 
Andrew J. Kelly
SQL Server MVP
"Jason B" <jasonb@kingschools.com> wrote in message
news:OvdnpUZyDHA.2304@TK2MSFTNGP12.phx.gbl...
> This may be an obvious question, but I've noticed that there are three
> settings for setting table level permissions to a user/role: Unchecked,
> Checked, and X'd. What is the significance of having THREE states? It
seems
> you would either grant or deny access. The default is unchecked - what
does
> this state imly, granted, or not? Do I have to go through and mark
> everythign with an X where I don't want user access, say for Update?
>
> Much thanks,
> Jason
>
>

Relevant Pages

  • Re: OT: WTF is a "Super Delegate"
    ... Rights are completely different than entitlements, privileges, etc. ... no person or governing body can ... insist that the word "grant" be used your BS is ripped apart. ... Rights," as Wyoming was the first government in the world ...
    (comp.sys.mac.advocacy)
  • Re: Setting rights by Outlook properties vs. AD
    ... This posting is provided "AS IS" with no warranties, and confers no rights. ... 60Subject: Re: Setting rights by Outlook properties vs. AD ... 60One clarification--the Mailbox Rights settings in AD also control who can ... 60> Microsoft Online Support Engineer ...
    (microsoft.public.exchange2000.general)
  • Re: Allow non-Administrator to view and terminate processes for all users
    ... programs" "right" under Security Settings, Local Policies, User Rights ... I verified using gpresult /v that the settings in the GPO had been applied ...
    (microsoft.public.windows.server.security)
  • Re: Regular Account unable to play DVD movie?
    ... Have you tried giving them the rights then logging on and making the settings changes required and then taking the rights away again? ... Just don't know why playing a simple DVD is such a major issues that requires Admin rights! ... I have User Control turned off. ...
    (microsoft.public.windows.vista.music_pictures_video)
  • Re: access to other mailboxes
    ... Sorry - I didn't realize how vague that sounded - go to the permissions tab ... of the recipient and grant the user Admin rights to the mailbox. ...
    (microsoft.public.exchange.admin)