public role
From: "Kevin Gurney" <k@c.co.uk>
Date: Thu, 27 Mar 2003 17:08:30 -0000
I've noticed, whilst reviewing rights granted to the public role, that it
has permissions
to query system objects within certain databases.
Can anybody explain why the public role needs this access and can/should
select
rights be safely revoked?
TIA.
Relevant Pages
- Re: change user1 access changes user2 access
... Using the public role is your problem. ... All users, whether it be User1, ... permission you are granting All users the permissions. ... > name, a password, I select a database to login to, then go ...
(microsoft.public.sqlserver.security) - Re: System Tables and Public Role
... databases is removed public from ALL the system tables. ... > I've been researching and researching but can't seem to find an answer to ... > Everything I read indicates that you should not grant permissions to the ... Am I to assume that the public role requires these ...
(microsoft.public.sqlserver.security) - Re: SMS View Tables access through ODBC - Help!
... > view tables is required for a feed to a third party asset management tool. ... Is public role necessary to access view tables? ... with a standard user account to make sure that nothing bad happened. ... enable the select permissions to the objects you want them to view. ...
(microsoft.public.sms.admin) - Re: change user1 access changes user2 access
... > Using the public role is your problem. ... >permission you are granting All users the permissions. ... I click on New Login. ... >> name, a password, I select a database to login to, then ...
(microsoft.public.sqlserver.security) - Re: Public Role in SQL Server 2000 SP3
... >The default permissions of the public role allow SELECT ... control security by user ... >> If I add a user to a database with Public Database ...
(microsoft.public.sqlserver.server) |
|
