Re: Permissions question?

From: Kimberly L. Tripp (Kimberly_PleaseReplyOnTheNewsGroups_at_nospam.sqlskills.com)
Date: 07/09/03 

Date: Tue, 8 Jul 2003 15:30:11 -0700

Didn't see the word table there...

The only way to give users access to a table when a table is NEW is to use
built-in roles NOT user defined. If you use db_datareader or db_datawriter
then users will have read or write access to ALL tables including new ones.

That's the only way that I know of for new objects to have permissions
associated with them by defualt, per se.

hth,
kt 

-- 
Please reply only on the newsgroups! Include dml/ddl, when possible.Thanks
Kimberly L. Tripp
President, SYSolutions, Inc. www.SQLSkills.com
Principal Mentor, Solid Quality Learning www.SolidQualityLearning.com
"Kimberly L. Tripp"
<Kimberly_PleaseReplyOnTheNewsGroups@nospam.sqlskills.com> wrote in message
news:ul2NZ6XRDHA.3192@TK2MSFTNGP10.phx.gbl...
> If you want EVERYONE to have those permissions then you can grant the
> permissions to the public role. Everyone is a member of public. Otherwise,
> you can add the user to a user-defined role when you add them to the
> database (wait, maybe that's what you were asking?).
>
> So - yes, you can create user-defined roles (see sp_addrole and
> sp_addrolemember in BOL) and then add users to it.
>
> hth,
> kt
>
> -- 
> Please reply only on the newsgroups! Include dml/ddl, when possible.Thanks
> Kimberly L. Tripp
> President, SYSolutions, Inc. www.SQLSkills.com
> Principal Mentor, Solid Quality Learning www.SolidQualityLearning.com
>
>
> "Mark S." <marks@netonegroup.com> wrote in message
> news:uY9NuYNRDHA.2592@TK2MSFTNGP10.phx.gbl...
> > Hello,
> >
> > Is there a way to setup a custom database role so that when a new user
> table
> > is added it automatically inheirits a default set of permissions?
> >
> > Any help would be greatly appreciated!
> > Thanks in advance.
> >
> >
>
>

Relevant Pages

  • Re: General Tab Permissions
    ... how are you giving these users access to change the data ... once the permissions have been granted to them? ... Ar eyou giving them RDP ... Empty fields are not exported. ...
    (microsoft.public.windows.server.active_directory)
  • Re: Do users need access to Windows or System32 Dir?
    ... that lead me to restrict the users access to the extreme, ... > Make sure that users have only Read permissions on the following ... > To find out which files or registry keys must be writeable by the ...
    (microsoft.public.windows.terminal_services)
  • Re: User permissions audit tools.
    ... > I just took over as Network administrator for a company with under 50 ... > employees. ... The previous N.A. didn't use groups and gave users access ... The syntax to just read the permissions ...
    (microsoft.public.win2000.general)
  • Re: File security
    ... what would be a way to give users access to change and update Word Documents, ... permissions for authenticated users and everyone and FOLDER permissions - I ...
    (microsoft.public.windows.server.sbs)