Re: Setting Table Permissions?
From: Jason B (jasonb_at_kingschools.com)
Date: 12/23/03
- Next message: Kevin McDonnell [MSFT]: "RE: Logon failed for user '(null)'..... error"
- Previous message: Andrew J. Kelly: "Re: Setting Table Permissions?"
- In reply to: Andrew J. Kelly: "Re: Setting Table Permissions?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Tue, 23 Dec 2003 13:09:05 -0800
Thank you very much Andrew!
Jason
"Andrew J. Kelly" <sqlmvpnooospam@shadhawk.com> wrote in message
news:u$%23w7cZyDHA.3888@tk2msftngp13.phx.gbl...
> 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
> >
> >
>
>
- Next message: Kevin McDonnell [MSFT]: "RE: Logon failed for user '(null)'..... error"
- Previous message: Andrew J. Kelly: "Re: Setting Table Permissions?"
- In reply to: Andrew J. Kelly: "Re: Setting Table Permissions?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
