Re: Set identity_insert

The user needs to own the object or needs to be a member of
either db_owner or db_ddladmin in the database to execute
this (or a syadmin on the instance).

-Sue

On Wed, 30 Aug 2006 20:37:58 +0200, "Ch."
<trotroyanas@xxxxxxxxxxx> wrote:

yes ok,

but the profil don't have right to create table !
and he does use command SET IDENTITY_INSERT
but have not right for use it !

what right i make on user for unlock this command ?

thanks




"Arnie Rowland" <arnie@xxxxxxxx> a écrit dans le message de news:
OdGaFnFzGHA.480@xxxxxxxxxxxxxxxxxxxxxxx
You don't grant permissions to the SET IDENTITY_INSERT statement.

Use the statement before an INSERT.

SET IDENTITY_INSERT dbo.MyTable ON

INSERT INTO MyTable
SELECT ....

SET IDENTITY_INSERT dbo.MyTable OFF

--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous


"Ch." <trotroyanas@xxxxxxxxxxx> wrote in message
news:elRaEHFzGHA.3360@xxxxxxxxxxxxxxxxxxxxxxx
hi,

i have a login with role who have rights
Grant Select, update, insert, delete, view definition to onLine --online
is role

but i want to attribute right SET IDENTITY_INSERT on my role

how can i do it ?

thank's





.