Re: Problem with role permissions

From: Kevin McDonnell [MSFT] (kevmc_at_online.microsoft.com)
Date: 12/12/03 

Date: Fri, 12 Dec 2003 01:35:18 GMT

from previous thread
" We are trying to set the premissions for the role(s). It is happening
for ANY role we
created and the public role. We are trying to revoke all rights to the
role public and grant access to some other role(s). The changed
permissions are not saved by the server, weither we use EM or Query
Analyzer to do this."

I would run profiler to capture this. Create a sample database, list out
the tsql commands and trace it using Profiler.
As Richard mentioned, if you have a repro of this, open up a case with us
and provide us the details.

Thanks,

Kevin McDonnell
Microsoft Corporation

This posting is provided AS IS with no warranties, and confers no rights.

Relevant Pages

  • SQL 6.5 - Rights - Not Working Correctly
    ... someone granted the SQL PUBLIC role with ... matter what specific rights you granted via user-defined ... The PUBLIC role has SELECT, INSERT, UPDATE & DELETE ... >rights issue with for certain SQL users that are a member ...
    (microsoft.public.sqlserver.security)
  • Re: Removing Permissions from the public role
    ... did you think about putting those 8 tables in a different schema, and then just granting rights to that schema, revoking the rights for that group from public. ... that user and ran some grant scripts to allow them to select from the 8 ... I see that there is a public role ... the public security role is still allowing the new login access to all ...
    (microsoft.public.sqlserver.setup)
  • Security infrastructure plan
    ... The DB's on our local test Server currently has everyone in the public role. ... Full - all rights to select, insert, update, delete, and DRI - System table ...
    (microsoft.public.sqlserver.security)
  • Re: DTS permissions to create
    ... The way I'd do it is remove (revoke and not deny) the exec ... rights from the public role and then create your own role with exec rights ...
    (microsoft.public.sqlserver.server)