Remove permissions in default Public Role?
Hello. Sorry if this is an obvious novice question but is ok and good
security practice to remove all permissions in the default Public Role in
SQL Server 2000? I create my own defined roles for each database and am
assumming it's good to remove every single permission in the Public Role
without anything breaking. Most of our databases we just need the regular
users to access the application tables and not any system tables or stored
procedures and was wondering it's ok to remove all of the Public Role's
permissions? Thanks in advance.
J
.
Relevant Pages
- Re: Newbie: I dont understand user permissions for table access
... > My database is remote to my workstation. ... > tables/fields WITHOUT specifying anything in the permissions dialogs? ... >> HOW are you connecting to SQL Server? ... what rights/permissions have been granted to the PUBLIC role? ...
(microsoft.public.sqlserver.server) - Re: PUBLIC ROLE
... think of the Public role as being very much ... > If I create a database called "TEST" and make a user George database ... you grant those permissions to the public role. ...
(microsoft.public.sqlserver.security) - Re: Remove permissions in default Public Role?
... functionality. ... in a database or when connecting to a database server. ... You'd want to make sure you are not granting permissions to ... happening because of the Public Role in the Master db. ...
(microsoft.public.sqlserver.security) - Re: Newbie: I dont understand user permissions for table access
... >My database is remote to my workstation. ... >> HOW are you connecting to SQL Server? ... >> If you are using NT auth, what rights does your NT ... the PUBLIC role? ...
(microsoft.public.sqlserver.server) - Re: Public role exists for any new login in sql server 2005
... public and deny's override grants, so no one would have access. ... Deny any permissions to public role ... I have a query regarding the Default Public role to any New SQL Server ...
(microsoft.public.sqlserver.security) |
|
