Permission changed by unkownn way

From: Aviel Iluz (aviel.iluz@pacmicro.com.au)
Date: 04/09/03 

From:     Aviel Iluz <aviel.iluz@pacmicro.com.au>
Date: Tue, 08 Apr 2003 21:50:48 -0700

Hello,

I have granted permission to Sql Server user (user + password, not Win
NT) as db_datareader and full permission on one table. this user connect
from a COM object to do some inserts to that table. when i give the
permission using Enerprise Manager, every thing looks fine; i connect to
Query Analyzer using this user login and i can select and insert to that
table. When i run the job that call to that COM object (the job calls sp
that calls sp that calls the Com object using sp_CreateOA etc.), the
permission for INSERT is deleted, and i can't insert to that table after
that. something has changed the permission after the user connected and
tried to make inserts in the COM object. What colud be the reason for
that and how can i avoid that.

Regards,

Aviel Iluz
Database Administrator
Pacific Micromarketing
Level 2, 616 St Kilda Road
Melbourne VIC 3004
Australia
Ph: +61 3 8517 3930
Fax: +61 3 9530 2350
www.pacmicro.com.au

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Relevant Pages

  • Re: Tightening E-Mail
    ... "Only those listed are granted permission: ... As for "Permissions for Submission and Relaying: ... Permission" - All else is not selected. ... Permission" is my server at 192.168.16.2 - is that right? ...
    (microsoft.public.windows.server.sbs)
  • Re: user permission to run job only
    ... I keep getting this message even though I granted permission to it already. ... >> I don't know what user permission to give for running SQL jobs only. ...
    (microsoft.public.sqlserver.programming)
  • Re: Zone Labs Pro question
    ... Taking a moment's reflection, David mused: ... | redefine it. ... program that has been granted permission, while that may be what you're ...
    (comp.security.firewalls)
  • Re: problem in exporting table from MSAccess to Oracle....
    ... and i dont think this user is not needed a read permission... ... "Joe Fallon" wrote: ... > I would create the table in Oracle. ... >> With best regards ...
    (microsoft.public.access.externaldata)
  • Re: undeliverable message
    ... Ok did not realize it was public folders. ... Regards ... > permission has already been set on both the exchange 5.5 and 2003 server ... >> Ben Hoffman ...
    (microsoft.public.exchange.admin)
Quantcast