g*****r
发帖数: 130 | 1 请问要 bulk insert 就一定要是 bulkadmin 吗。
I don't want to give bulkadmin to everybody in the team, but they have to
run a stored procedure that has a bulk insert statement. Is there other ways
to grant them permissions? Thank you. |
y****w
发帖数: 3747 | 2 做个表，比如叫做bulk_request，上面放个trigger可以根据insert的内容bulk insert
。你只要给他们insert就行了。 善后的可以用pipe或某字段或另一个表通知他们干完
活儿了。怕滥用的话加些constraint。
have to
other
ways
【在 g*****r 的大作中提到】
: 请问要 bulk insert 就一定要是 bulkadmin 吗。
: I don't want to give bulkadmin to everybody in the team, but they have to
: run a stored procedure that has a bulk insert statement. Is there other ways
: to grant them permissions? Thank you.
|
g*****r
发帖数: 130 | 3 谢，头像照片很可爱地说。
insert
【在 y****w 的大作中提到】
: 做个表，比如叫做bulk_request，上面放个trigger可以根据insert的内容bulk insert
: 。你只要给他们insert就行了。 善后的可以用pipe或某字段或另一个表通知他们干完
: 活儿了。怕滥用的话加些constraint。
:
: have to
: other
: ways
|
