Post reply

Missing Public Role

  • October 25, 2009 at 8:38 pm

    #211452

    Hi,

    I have this sql server 2005 and I started encountering some permission issues e.g.for a stored procedure the execute permission is set explictly, it is in that list but not showeing in the effective permissions. And that user it cannot execute the procedure ...

    Noticed that there is no public server role showing in the server!! How can that be possible?

    Thank you

    Adrian

  • October 25, 2009 at 9:04 pm

    #1070495

    How is security set? Is EXECUTE granted for the user? Or for a role the user is a part of?

    Is EXECUTE denied anywhere, for the schema or procedure?

    Public should be there, but you should typically not grant any permissions to public. It's a bad idea and removes some flexibility you might have for permissions in the future.

    Note: Please don't cross post to multiple forums.

  • October 25, 2009 at 9:09 pm

    #1070497

    Thank you for your message.

    There is no deny anywhere and the permission I tried to grant both ways, role and user, with the same result. But what puzzles me is the missing public role, how can that be?

    Adrian

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply