Re: DTS permissions to create

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Paul Ibison (Paul.Ibison_at_Pygmalion.Com)
Date: 06/23/04 

Date: Wed, 23 Jun 2004 11:00:23 +0100

The rights are inherited by virtue of the guest user and the permissions of
the public role. 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
to the 2 procedures I mentioned. If a user needs to be able to use them,
then add him explicitly as a user in MSDB and into your role.
HTH,
Paul Ibison

Relevant Pages

  • Re: Revoking public permissions
    ... We have many databases with all rights to user tables, views, stored ... (I have never tried to revoke public rights to the ... the public role in the system databases. ...
    (microsoft.public.sqlserver.security)
  • 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)
  • Re: Problem with role permissions
    ... " We are trying to set the premissions for the role. ... created and the public role. ... I would run profiler to capture this. ... This posting is provided AS IS with no warranties, and confers no rights. ...
    (microsoft.public.sqlserver.security)
  • 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)