Removing Stored procedure exec access for a secific user

Hello Ramachandran M,

 

 

i need to block the access of a specific user to every table which is start with "pdart_XXXX_XXXXX "  except one table "pdart_Timelog_xxxxx" .

 

Try this

 

select database login-->Go to Securable and click on Search button as in the preceding image. On clicking the Search button, you’ll find he following window to add the type of object.

Click on Object Types button and you’ll get “Select Object Types” window with various objects. Now if you see, stored procedure is listed in the object types area. Now we’ll select our specific stored procedure on which we want to provide permission.