Are you talking programmatically or interactive...
If you are 9.2 and have an unrestricted login, you can click on the advanced button for on the authorisation tab for the Storedprocess in SMC. You can then see what the applied permissions are for that object for any person/group
Barry