Confysed by the roles
From: Jim Abel (JimAbel_at_discussions.microsoft.com)
Date: 08/16/05
- Next message: Earl Newcomer: "Why would a table owner have to prefix his objects with his own na"
- Previous message: Andrew J. Kelly: "Re: Implementation of Replication Topologies"
- Next in thread: Sue Hoegemeier: "Re: Confysed by the roles"
- Reply: Sue Hoegemeier: "Re: Confysed by the roles"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Tue, 16 Aug 2005 09:31:09 -0700
DaI have an application that uses the Extended Stored Procedures sp_OA...
I thought that I read that members of the System Administrators Role could
access the Extended Stored Procedures in the Master Databasewithout
specifically granting execute permissions on each procedure. When the sorce
code executes an error stating that "EXECUTE permission denied on
'sp_OACreate', database 'master', owner 'dbo'
I then granted the user the Execute permissions and had the same error
message
I then Granted the Execute Permissions to Public and it worked
I then removed the permissions from the user and it still worked.
So in the end just adding the Public made this work BUT to reduce my
security risks I would prefer not to give Public the rights to execute the
Extended Stored Procedures.
Can this be done? if so how?
- Next message: Earl Newcomer: "Why would a table owner have to prefix his objects with his own na"
- Previous message: Andrew J. Kelly: "Re: Implementation of Replication Topologies"
- Next in thread: Sue Hoegemeier: "Re: Confysed by the roles"
- Reply: Sue Hoegemeier: "Re: Confysed by the roles"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]