SQL Server Performance

Table Data Type

Discussion in 'T-SQL Performance Tuning for Developers' started by CSharpFriends, Nov 7, 2002.

  1. CSharpFriends New Member

    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.

  2. satya Moderator

    Its purely depends on the privileges of the table where you create this variable.

    Satya SKJ
  3. burbakei New Member

    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.

Share This Page