When I look, using SQL Server 2005 SP2 tools and server, I see: Alter.
Control, References, SELECT, Take Ownership, and View Definition. But no
Update.
In any case, Update, Insert, and Delete make no sense since a Table-valued
Function is Read Only.
How do delete permissions work for Table Value Functions?
When I look at the Permissions Property on a Table Value Function I see
that
I can set Select and Update but not delete?
Store program EXE in table? ... I have remote control software... my application uses as its data storage system MSDE 2000 (with ... since I already have SQL Server running on the network I'd like ... Is there some way that I can either a) store my program files (one EXE ... (comp.databases.ms-sqlserver)
Re: SQL Server 2000 speed problems ... >> CREATE TABLE Control... >> This is done by inserting a new row with the current time into the ... >> written to the database, and the writing needs to be fast, in the region ... >> similar that can be changed on SQL Server that could help solving this ... (microsoft.public.sqlserver.programming)
Re: DBA Access to SQL Server ... > look at the qualifications or trust of your sql dba... > rather than his/her permissions.... > 99.9% of the time i hear this question it's a control... if your support model includes the DBA folks doing the SQL Server... (microsoft.public.sqlserver.security)
Re: :: Control user access ... IMO it totally depends on the nature of the application. ... As you indicate SQL Server involvement,... Microsoft MVP (Windows Security)... > way to control user access in my application. ... (microsoft.public.security)
Re: using lookup and display only field as control field ... The control table would have only one row. ... assosciation between the two tables if the key field was null in both ... Of course, the syntax above is specific to SQL Server, but it's the ...Books Online for SQL Server 2005 at ... (comp.databases.ms-sqlserver)
