Re: SqlBulkCopy permissions

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Sorry I didn't realize you were using the class. Of course I had also
assumed that you had set
SELECT privileges on the table since it's rather difficult to do anything
when you can't see it in
the first place. ;-)


If I was the DBA, it would have SELECT privileges, but alas that is not the
case. Our DBA wants as limited access as possible. Elsewhere someone was
mentioning that if you wanted db-logging, you would probably also need
ADMINISTER BULK COPY, but we don't need that, so we're sticking with INSERT
and SELECT.

Thanks,

-BKN


.

Relevant Pages

  • Re: Permsssions to create sql profiles
    ... for some databases I do not have dba privileges. ... advisor role still gives some access errors. ... be true with sql profile as well. ...
    (comp.databases.oracle.server)
  • Re: Permsssions to create sql profiles
    ... for some databases I do not have dba privileges. ... advisor role still gives some access errors. ... be true with sql profile as well. ...
    (comp.databases.oracle.server)
  • Re: ansi outer join syntax in Oracle allows access to any data
    ... Tested as a user with some privs (but not DBA or SELECT ANY TABLE) as below ... Oracle8i Enterprise Edition Release 8.1.6.3.0 - Production ... > bug in the ANSI outer join syntax. ... > or what privileges that user has. ...
    (Bugtraq)