Re: Set identity_insert

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: Granting GRANT permissions
    ... Creators of stored procedures (standard users with CREATE PROCEDURE rights) ... can grant permissions on their own procedures to other users. ... "Josh N." ...
    (microsoft.public.sqlserver.security)
  • Re: Granting GRANT permissions
    ... How do I allow a user to create a stored procedure for 'dbo' without giving ... that errors out saying you can't use AS when granting those rights. ... > can grant permissions on their own procedures to other users. ...
    (microsoft.public.sqlserver.security)
  • Re: mask one users permission level to another
    ... Alternatively if you are using NT Authentication you can ... and grant permissions to a NT User group; you would then only need to add ... the users to that NT User group. ... > If there is a user A that has been granted certain rights on certain ...
    (microsoft.public.sqlserver.security)