PUBLIC db role

From: Aramid (aramid_at_hotmail.com)
Date: 08/25/05 

Date: Thu, 25 Aug 2005 22:11:47 +0800

Dear everyone,

I would like to know if there will be an issue if I strip the PUBLIC
database role of ALL permissions it is assigned by default. I was
thinking of creating a new role, say EVERYONE, and moving all default
permissions that PUBLIC has to this new role.

Will this have any operational impact? Has anyone does this or know
of any publicly-available script that does this?

Thanks.

Aramid

Relevant Pages

  • Re: weird problem with chkrootkit and checksums
    ... > (including overwriting files in use, copying files across filesystems, ... > preserving or modifying ownership and permissions as necessary). ... > strip the debugging information, unless you have not explicitly told ...
    (FreeBSD-Security)
  • Re: Roles
    ... This was my solution after first using EM and scripting the SP without current Permissions: ... from sysobjects where xtype='P' ... > I need to take about 300 SP's and strip out whatever permissions are ...
    (microsoft.public.sqlserver.programming)
  • RE: Roles based security 2005 versus 2000
    ... Right-Click on the Database Role and select Properties ... In the Properties Dialog select the SECURABLES page ... Product team remove this feature to optimize the ... active and if you try to grant the permissions again by select the ...
    (microsoft.public.sqlserver.security)
  • Re: Why securities disappear in SQL Server 2005 ?
    ... Do you consider that an enhancement to a 5 years old tool - Enterprise ... objects and it should show you permissions that you have already given on ... database role then from role securities tab i assign permissions to ... securities to users then everything is ok, ...
    (microsoft.public.sqlserver.security)
  • RE: how to deal with public role?
    ... All databases contain a public database role of which all users, ... roles are members. ... Do not grant additional permissions to this role. ...
    (microsoft.public.sqlserver.security)