Re: SqlBulkCopy permissions

Requires INSERT and ADMINISTER BULK OPERATIONS permissions. Additionally,
ALTER TABLE permission is
required if one or more of the following is true:


Is that even possible? I didn't think SQL Server allowed granting ALTER
TABLE, I thought you had to be owner of the table or database to be able to
do that...

-BKN


.

Relevant Pages

  • Re: Complete Neophyte Question(s)
    ... I have a user named james on a database. ... WITH GRANT is one of the more esotheric features in SQL Server in my ... Or does that depend on the permission? ... CREATE USER erik ...
    (microsoft.public.sqlserver.security)
  • RE: security problems with AD and SQL Server 2000
    ... I believe it is SQL server permission ... >The System developers group is placed into each users section of the ... >database for permitting database access to each database. ...
    (microsoft.public.windows.server.active_directory)
  • Re: Alter Many Stored Procedures
    ... Books Online for SQL Server SP3 at ... >> What permission do I need to setup for a developer in order to change ... >> stored procedures in ABC database? ... Developer windows group is added to ...
    (microsoft.public.sqlserver.security)
  • Re: ASP page and SQL server error
    ... It's not the account, it's the priveleges that the account has with regards ... SQL Server permissions are very granular. ... while the user has permission to USE the database (in a general ...
    (microsoft.public.frontpage.programming)
  • Re: How to connect to an SQL Server 2000 Personal Edition Database
    ... You've got to give the aspnet worker process the permission to the database, add a new login from your Windows Account. ... Otherwise you've to run impersonnation or use sql authentication. ... I have created a web service that needs to access data in an SQL Server 2000 ...
    (microsoft.public.dotnet.framework.webservices)