Home > database >  SQL Server user permissions
SQL Server user permissions

Time:01-07

Consult everybody masters
I use environment is SQL Server
I want a user to a library
Had the query access but not modify permissions

So I gave db_datareader
But the problem to the
The user can query table (table) and a data table value function (table function)
But he can't query scalar valued function (scaler function)
If a table value function in the package a scalar function, the man couldn't query

Excuse me, how do I set the
To make the user can query table, table value function, scalar valued function
But it can't modify

Thank you for your superior answer

  • Related