Post reply

SP create permission confusion

  • June 11, 2007 at 7:55 am

    #62907

    I have a new DB on an existing server and cannot figure out why the users are able to create their own stored procedures!

    The users are not members of any server roles, and the only database roles they appear in is the public role. Apart from that they have select/insert etc permissions on varying numbers of tables/views and are able to create SP's.

    The users are not granted the Create SP permission on the database level, although it has not been denied either..... Any ideas??

  • June 11, 2007 at 9:17 am

    #712011

    Gunter,

    Are the users members of a group that has higher level permissions or is Public a member of a database role with higer level permissions?  You wouldn't see the permissions for the individuals in either case.

    Greg

    Greg

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

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