powerdrivehp
asked on
MS SQL - Change login Account to View Table Value Function as Read-Only
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.