Re: delete some user from the public role

• Previous message: Jasper Smith: "Re: delete some user from the public role"
• In reply to: Jasper Smith: "Re: delete some user from the public role"
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]

Date: Thu, 9 Sep 2004 18:09:03 -0700

Hello Jasper. Well, really my problem is related with a DTS execution.
I have some application in Visual Basic 6, and I create a DTS in my local
machine (my local SQl Server), and when I try to execute the DTS from the
application I have no problems , but when I put this DTs in some remote SQL
server, and then I try to execute my application, I obtain this message:
EXECUTE permission denied on object 'sp_get_dtspackage', database msdb,
owner 'dbo'
I when I review I can see that the problem is because I denied the
privileged for this SP to a public role (if I simple take out the denied I
have no problem).
I don't like to take out this 'denied' to the public role, because it can be
dangerous, I like to know if I have another way to resolve this. Thanks

"Jasper Smith" wrote:

> No, all users are members of the public role and you can't remove the role
> or add/remove users from it.
>
> --
> 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
>
> "Claudia Holzer" <ClaudiaHolzer@discussions.microsoft.com> wrote in message
> news:6303BA5F-C494-48C7-8F20-A08EFB3F6554@microsoft.com...
> >I like to know if I can delete some user for the public role?. When I
> >create
> > some user, by default he is assign to the public role, if I assign some
> > other
> > role, I can't delete the link between the user and the public role. Thanks
>
>
>

• Previous message: Jasper Smith: "Re: delete some user from the public role"
• In reply to: Jasper Smith: "Re: delete some user from the public role"
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]