Post reply

Object Permissions

  • December 19, 2005 at 12:13 pm

    #170192

    Hi,

     I have question regarding object permissions:

     

    I have a DB user 'ABC' who can execute a stored procedure 'SPROC'. However, I when i use the Enterprise Manager to view the permissions on the stored proc 'SPROC', i don't see the EXEC column checked for user 'ABC', but the user can still execute 'SPROC'. Infact i viewed several stored procs and none of them had the EXEC column checked, but the users can still execute these SPs.

    How is this possible? Is there some kind of default permissions?

     

    Thanks,

    Rajesh

     

  • December 19, 2005 at 1:37 pm

    #610431

    The first thing I would check is whether the user belongs to a server level role which by default would have execute permissions, such as dbo, or sysadmin.  Second, I would see if there are any roles which do have the column EXEC checked in the SPROC permissions.  If so, again the user may be a part of this role.  The only other thing I can think of is if the public group has been given execute permissions then all users would be able to execute as well.

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

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