SQL Server Performance Forum – Threads Archive

Table Data Type

Whenever 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.
~webmaster
http://www.csharpfriends.com

---

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.

---

]]>