Execute the sp_objectpermission stored procedure to generate a report on object-level privileges granted to the specified role or user name or object privileges granted on the specified object or dbspace.
The report includes the user ID of the privilege grantor and grantee, the object name and owner, the privilege granted and whether the grantee can in turn grant the privilege to other users.
No system privileges are required to execute the procedure on your user ID. To execute sp_objectpermission on other users or a dbspace, you must have MANAGE ANY OBJECT PRIVILEGE or MANAGE ANY DBSPACE privilege, respectively.