Bulk copy failed user does not have alter table permission
来源:互联网 发布:sql语句建表 列名别名 编辑:程序博客网 时间:2024/05/17 13:10
The question is whether the triggers and constraints should be fired or not. If so, specifying FIRE_TRIGGERS and CHECK_CONSTRAINTS would prevent the need to alter the table. (The ALTER is disabling the triggers and constraints so that the bulk insert will run more quickly.)
When triggers and constraints are disabled, they are disabled for everyone, not just the bulk process. (Otherwise it would not be necessary to ALTER the table.) So that does leave a window of time when other operations also are not having these features enforced.
One option is to run a process as:
- Stored procedure to Disable Triggers and Constraints
- BULK INSERT
- Stored procedure to Enable Triggers and Constriants
The stored procedures could do the needed work (running as dbo) without giving the rights to the user doing the bulk insert. This opens the window of the disabled time period slightly wider, but not too bad.
An alternative could also be to BULK INSERT into a staging table that has no triggers and constraints, then use a stored procedure to move the data from the staging table into the target table.
- Bulk copy failed user does not have alter table permission
- java.lang.SecurityException: Sending SMS message: User 10034 does not have android.permission
- User <anonymous> does not have permission on weblogic.management.adminhome to perform lookup operati
- SSRS 2014 User Domain\User does not have required permissions.
- User Domain\User does not have required permissions
- The file is absent or does not have execute permission
- mac安装jello,安装不过去,报gyp WARN EACCES user "root" does not have permission to access the dev dir "/root/
- sql server 2012 reporting service 用户权限访问问题 User 'Domain\user' does not have required permissions
- 启动tomcat 服务报 The file is absent or does not have execute permission
- 启动tomcat 服务报 The file is absent or does not have execute permission
- goagent: 403 Your client does not have permission to get URL /2 from this server
- Your client does not have permission to get URL /2 from this server
- java.lang.SecurityException: Sending SMS message: uid 10047 does not have android.permission.SEND_SM
- Cannot find bin/catalina.sh The file is absent or does not have execute permission
- 启动tomcat 服务报 The file is absent or does not have execute permission
- 启动tomcat 服务报 The file is absent or does not have execute permission
- linux 启动tomcat 服务报 The file is absent or does not have execute permission
- 启动tomcat 服务报 The file is absent or does not have execute permission
- Android多任务下载,使用Notification更新进度条
- MFC单例运行三种方式
- 不想当业务员的培训经理不是好的CEO
- Grunt中批量无损压缩图片插件--Grunt-contrib-imagemin
- android4.0强制横屏竖屏
- Bulk copy failed user does not have alter table permission
- [转]Linux常用C函数-内存控制篇
- com学习(五)——实现多接口
- 总结 20 个开发细节
- ubuntu12.20安装 hadoop2.2.0伪分布式
- PREEMPT_RT的未来
- leetcode 15 Single Number II
- spark启动master时提示端口8080被占用SelectChannelConnector@0.0.0.0:8080: java.net.BindException
- Android Studio对真机和模拟器进行截图