 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / General / Security / August 2006Set identity_insert
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 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  SignatureArnie Rowland, Ph.D. Westwood Consulting, Inc Most good judgment comes from experience. Most experience comes from bad judgment. - Anonymous > hi, > [quoted text clipped - 7 lines] > > thank's 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 > You don't grant permissions to the SET IDENTITY_INSERT statement. > [quoted text clipped - 18 lines] >> >> thank's 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. SignatureArnie Rowland, Ph.D. Westwood Consulting, Inc Most good judgment comes from experience. Most experience comes from bad judgment. - Anonymous > yes ok, > [quoted text clipped - 28 lines] >>> >>> thank's 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 >yes ok, > [quoted text clipped - 28 lines] >>> >>> thank's |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.