UDF & DATABASE ROLE problem

From: "Sagaert Johan" <REMOVEsagaert_j@xxxxxxxxxxx>
Date: Thu, 25 May 2006 18:15:11 +0200

Hi

I have an exception when an UDF is called that does a SELECT , the user is
in the db_datareader role list ,so using a select should be no problem
( my other selects from stored procedures poses no problem )

Is there an issue when using UDF's and server roles ?

Johan

.

Follow-Ups:
- Re: UDF & DATABASE ROLE problem
  - From: Sagaert Johan

Prev by Date: Re: 17805 Starting up Java App server, with SQL Server 2000 Backend
Next by Date: Re: UDF & DATABASE ROLE problem
Previous by thread: ArcSDE 8.2 with SQL Server 2000
Next by thread: Re: UDF & DATABASE ROLE problem
Index(es):
- Date
- Thread

Relevant Pages

Re: UDF & DATABASE ROLE problem
... The culpritt seems to have to do sometihing with Executescalar ... I have an exception when an UDF is called that does a SELECT, ...
(microsoft.public.sqlserver.clients)
User defined Function datetime parameter bug ??
... SQL Server 200 as: ... When i test this UDF From Visual Studio 2003 Server Explorer->Sql ... although no exception is generated the result is 0 for any date as ...
(microsoft.public.dotnet.framework.adonet)
Re: Trap 000e in UDF
... INFORMATION ZUR ALARMNACHRICHT (TRAP) ... Exception in module: UDF ...
(comp.os.os2.bugs)