SQL Server Performance Forum – Threads Archive
Table Data TypeWhenever we create a variable of type table, are permissions/rights created for this table? Basically what I am asking is if the data type ‘table’ under goes all the overhead of creating a regular table. Obviously this is not the case as it would be very slow in camparison to its current speed…Just curious to know all the details regarding this.
Its purely depends on the privileges of the table where you create this variable. Satya SKJ
if other users have EXECUTE permission on the functionn they can use the function.
but if your function create a real table (sorry for the term real) or alter them they must have REFERENCES permission to the function.