Re: SQL Server Application roles

I've defined subclasses of TThread that are initializated with the main
datamodule's adoconnection. Each X seconds an ADOCommand is executed. This
execution is which causes the exception.

"Kevin Frevert" <kevin@xxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:43e755f2$1@xxxxxxxxxxxxxxxxxxxxxxxxx
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

  • 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)
  • Re: Execute Persmission denied on object sp_OACreate
    ... SQL Server doesn't check permissions on indirectly referenced objects as ... You can prevent ad-hoc execution of powerful master database procs while ... >I have a user who has execute permissions on a store procedure in a>database> which in turns executes 4 stored procedures in the master database. ...
    (microsoft.public.sqlserver.security)
  • Re: Connecting to Sql Server 2005
    ... When you create the logon (or alter the login) in Enterprise Manager ... allows it the permissions it will need. ... executes the sp's I get the infamous EXECUTE permission denied on object ... I am using sql server authentication - I created a SQL server user in the ...
    (microsoft.public.dotnet.general)