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
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.