MS SQL - Change login Account to View Table Value Function as Read-Only
Posted on 2013-05-13
I have a login account called 'DBProcessMe'.
I want to change the permissions of this login account to open a table value function called
'FnProcessMyData' as read only.
Currently, users can open this function and
(1) alter the function, or (2) create a duplicate function by changing 'Alter to "Create".
I only want them to read the function only.
What is the best method to do this?
I am familiar with the system tables, database members, roles, etc.