Re: PUBLIC db role

From: Jasper Smith (jasper_smith9_at_hotmail.com)
Date: 08/25/05


Date: Thu, 25 Aug 2005 22:54:14 +0100

What are you trying to achieve?

-- 
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Aramid" <aramid@hotmail.com> wrote in message 
news:66krg11l6rcm4e7lmsolt354r249mt356c@4ax.com...
> 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: Restricting access to rows of table(s)+WRITE rights in SQLsrvr2k
    ... one with select permissions and another with select, insert, update, delete ... Wayne Snyder, MCDBA, SQL Server MVP ... of SQL Server professionals. ... > and the other-with Read+WRITErights. ...
    (microsoft.public.sqlserver.security)
  • Re: Using script to list users and their allocated security
    ... Now that I think about it, I doubt the views include permissions obtained ... Wayne Snyder, MCDBA, SQL Server MVP ... community of SQL Server professionals. ... > a SQL Server 2000 database with read permissions or write permissions via ...
    (microsoft.public.sqlserver.server)
  • Re: Securing a Custom Application
    ... Do I need to revoke any permissions from Administrators or the sa account? ... > can encrypt the password over the wire using ODBC encryption. ... > Wayne Snyder, MCDBA, SQL Server MVP ... > community of SQL Server professionals. ...
    (microsoft.public.sqlserver.security)
  • Re: Getting a list of Stored Procedures
    ... permissions associated with an object.... ... Wayne Snyder, MCDBA, SQL Server MVP ... community of SQL Server professionals. ... "Craig G" wrote in message ...
    (microsoft.public.sqlserver.programming)
  • Re: Getting a list of Stored Procedures
    ... It is doc's in books on line and gives you ... > permissions associated with an object.... ... > Wayne Snyder, MCDBA, SQL Server MVP ... > community of SQL Server professionals. ...
    (microsoft.public.sqlserver.programming)