Re: Set identity_insert

You did not indicate that the problem is with creating a table.

A role (or user) MUST have CREATE TABLE permission in order to create
tables.

It would help us better assist you if you could include table DDL, query
strategy used so far, sample data in the form of INSERT statements, and an
illustration of the desired results. (For help with that refer to:
http://www.aspfaq.com/5006 )



The less 'set up' work we have to do, the more likely you are going to have
folks tackle your problem and help you. Without this effort from you, we are
just playing guessing games.


--
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:%23RleuNGzGHA.480@xxxxxxxxxxxxxxxxxxxxxxx
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







.

Relevant Pages

  • Re: SMSS - script to new window uses sp_executesql?!
    ... I went to the Connect site, but it says "You need permission to submit ... There is a new set of options for generating scripts in SQL Server 2005 SP2. ... Arnie Rowland, Ph.D. ... Most good judgment comes from experience. ...
    (microsoft.public.sqlserver.tools)
  • Re: Set identity_insert
    ... but the profil don't have right to create table! ... and he does use command SET IDENTITY_INSERT ... Most good judgment comes from experience. ... Grant Select, update, insert, delete, view definition to onLine --online ...
    (microsoft.public.sqlserver.security)
  • Re: Domain or Workgroup
    ... Arnie Rowland, Ph.D. ... Most good judgment comes from experience. ... to connect to a server and not being properly configured. ... installed, since better security is now available, file storage may be ...
    (microsoft.public.sqlserver.clients)
  • Re: Domain or Workgroup
    ... comments which contradict others' suggestions or material in a ... Arnie Rowland, Ph.D. ... Most good judgment comes from experience. ... to connect to a server and not being properly configured. ...
    (microsoft.public.sqlserver.clients)
  • Re: Domain or Workgroup
    ... Arnie Rowland, Ph.D. ... Most good judgment comes from experience. ... to connect to a server and not being properly configured. ... installed, since better security is now available, file storage may be ...
    (microsoft.public.sqlserver.clients)