Application Role - Server side cursor

From: Dolores Young (dolores.young@ayrdata.com)
Date: 07/25/02 

From: "Dolores Young" <dolores.young@ayrdata.com>
Date: Wed, 24 Jul 2002 19:30:20 -0700

I developed a small application to test the possibilty of
implementing security on a system via an application role.
After I added my test user to the db_denydatareader and
db_denydatawriter roles, he ran the application and
everything worked as expected!

When we then tried to implement the application role on a
real-live application, the test user was denied access to
the database when running the application.

The real application uses server-side cursors, and the
developers feel this is why the application role doesn't
work.
Any ideas?
Thanks
Dolores

Relevant Pages

  • Re: Application Role - Server side cursor
    ... a problem with connection pooling from the client--approles aren't ... >implementing security on a system via an application role. ... the test user was denied access to ... >developers feel this is why the application role doesn't ...
    (microsoft.public.sqlserver.security)
  • Dimension Security Problem
    ... I'm still having a bit of trouble with my security settings. ... All security is set up on the cube role ... members of Dim1 Field1 instead of just the few members that our test ... I've checked the msmdqlog table and the test user is logged as the ...
    (microsoft.public.sqlserver.olap)