Posted by Peter Nurse on 11/21/06 06:34

Uri Dimant wrote:
> Hi
> Grant EXECUTE permissions on stored procedure to the specific user

Thanks Uri,

Yes, all users already have EXECUTE permission - that's not the
problem. Remember that in the original post, I said . . .

In the above example, if the SPs are owned by dbo (as above),
CREATE
TABLE & DROP TABLE use MyUser.tblTest while INSERT & SELECT use
dbo.tblTest.

.. . . that refers to the behaviour when executed by a non-dbo (shall we
call them underprivileged?) user.

• Next in forum: Re: Default Table Owner using CREATE TABLE, INSERT, SELECT & DROP TABLE
• Prev in forum: Re: Default Table Owner using CREATE TABLE, INSERT, SELECT & DROP TABLE
• Thread view: Re: Default Table Owner using CREATE TABLE, INSERT, SELECT & DROP TABLE

[Reply to this message]