Set 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


.

Relevant Pages

  • Re: Complete Neophyte Question(s)
    ... No you cannot remove a login from the 'public' role. ... For rights to _use_ objects then the appropriate rights need to be granted ... GRANT SELECT ON dbo.Orders TO OrderViewers ... for a database that is supposed to be secured it is a bad idea ...
    (microsoft.public.sqlserver.security)
  • Re: Removing Permissions from the public role
    ... did you think about putting those 8 tables in a different schema, and then just granting rights to that schema, revoking the rights for that group from public. ... that user and ran some grant scripts to allow them to select from the 8 ... I see that there is a public role ... the public security role is still allowing the new login access to all ...
    (microsoft.public.sqlserver.setup)
  • Re: Transact: GRANT LOGIN
    ... CREATE LOGIN, continue to use it and you don't need to use sp_grantlogin. ... I still need to grant access to individual ... databases and give rights to SELECT, UPDATE, etc. ... After successfully creating a "newUser' login, ...
    (microsoft.public.sqlserver.programming)
  • Re: No db access after publishing web site
    ... GRANT UPDATE TO ... If I detach and attach this database on a different PC (according that PC ... Cannot open database "pago" requested by the login. ... Are you detaching/attaching the SQL Server Express database correctly ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Normal user login now logs off immediately [w/o administrator
    ... The login begins in a normal fashion: ... >> problem I happened to give my normal user account administrator rights, ... > Right click on MountedDevices and select "Permissions". ... Thanks for the reply WTC. ...
    (microsoft.public.windowsxp.general)