Re: SQL Server Application roles

Gaspar,

How are you executing your query 'in a separate thread'?

krf

"Gaspar" <noreply@xxxxxx> wrote in message
news:43e74803@xxxxxxxxxxxxxxxxxxxxxxxxx
I started using application roles but I have problems with database queries
that are executed in separated threads.

This is the scenario:
1) I connect to SQL Server 2005 with a user that only has CONNECT
permissions (i.e no permissions for select, update, etc.)
2) I execute sp_setapprole with an application role that has full access
to databases (just for testing).
3) Everything goes ok, I conect to table, open queries, etc., BUT if I
execute queries in a separated thread I get a "You haven't SELECT
permission on table XXX".

I read http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q229564
about OLEDB resouces pooling. I tried including the "OLE DB Services= -2"
string in ADOConnection.ConnectionString but It didn't seem to help.

Other ideas?



.

Relevant Pages

  • SQL Server Application roles
    ... I started using application roles but I have problems with database queries ... that are executed in separated threads. ... I execute sp_setapprole with an application role that has full access to ...
    (borland.public.delphi.database.ado)
  • Re: SQL Server Application roles
    ... queries that are executed in separated threads. ... permissions ... I execute sp_setapprole with an application role that has full access ... Everything goes ok, I conect to table, open queries, etc., BUT if I ...
    (borland.public.delphi.database.ado)
  • Solaris 10 autofs directory permissions - Solution
    ... the fact that my map file has 755 permissions not 644. ... If the execute permission is set, it becomes an executable map which is ... map is expected to return the content of an automounter map ...
    (SunManagers)
  • Re: Rights to execute jobs?
    ... Does anyone know if the rules surrounding stored procedure permissions apply ... Does this apply to a proc calling sp_start_job so that I ... raise the alert, so it could be anyone on the server. ... is that a group needs to not be an admin but still be able to execute ...
    (microsoft.public.sqlserver.security)
  • Re: Newbie
    ... I will now tell you some basic commands. ... Easy file has rights and a owner. ... file and who may execute it. ... The last three characters are about the permissions of user ...
    (alt.linux)