Re: Table Type Permissions

Users need EXECUTE permissions in the table type in order to use the type to pass table-valued parameters to a stored procedure. REFERENCES permission on the type is needed for a user to create a stored procedure that uses the type as a parameter.

--
Hope this helps.

Dan Guzman
SQL Server MVP
http://weblogs.sqlteam.com/dang/

"Daniel Jameson" <no_djameson_spam@xxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:%23S4gT0CLKHA.1336@xxxxxxxxxxxxxxxxxxxxxxx
Hi,

The SQL 2008 BOL topic on GRANTing permissions to TYPEs is not explicit on what the results of granting specific permisisons are. In particular, what are the results of GRANT EXECUTE ON TYPE::MyType and GRANT REFERENCES ON TYPE::MyType? I'm particularly interested in table types and using them for table valued parameters in stored procedures.

--
Thank you,

Daniel Jameson
SQL Server DBA
Children's Oncology Group
www.childrensoncologygroup.org




.

Relevant Pages

  • Multiple Database Security - How to handle
    ... The problems are security maintenance. ... to the store procedure and permissions to the DM for the ... a stored procedure that accesses DM to get employee info. ... has execute permissions then the procedure is executed as ...
    (microsoft.public.sqlserver.security)
  • app role has exec permission but still cant execute sp
    ... I've set up an application role in my SQL2K database as ... well as some users with no permissions. ... (including execute permissions) ... when I try to execute a stored procedure through ...
    (microsoft.public.sqlserver.security)
  • Re: Stored Procedure and Table permissions
    ... execute permissions on the stored procedure. ... >given the user EXEC permission for the stored procedure. ...
    (microsoft.public.sqlserver.security)
  • Re: what account does the server use to run sp
    ... >>the stored procedure. ... Check user's permissions on the table reported in the ... >>EXECUTE permissions, ...
    (microsoft.public.sqlserver.security)
  • Re: Deny access to all users (including Administrator and DomainAd
    ... permissions on stored procedure override ... applictaion's user account permissions to the stored procedure which will ... Will try to deny access through the query for SQL Server 2005 and 2000. ... Remove everyone that you don't want rom an Administrator Groups ...
    (microsoft.public.sqlserver.security)
Loading