June 28, 2004 at 8:38 am
Hello All,
How does one permit the setting of values for insertion into an identity field when the user is not the dbo, or have administrative priviledges (permission)?
Greg
Greg Hannah
June 28, 2004 at 4:12 pm
Put it into a stored procedure and give exec rights to the procedure.
Steve
June 28, 2004 at 4:22 pm
Thank you Steve
This was attempted, but the user's permissions with regards to the SET operation were not permitted within the stored procedure. The error produced was the exact same as if it were generated outside of a sp.
Greg
Greg Hannah
June 28, 2004 at 9:44 pm
From Books Online:
Execute permissions default to the sysadmin fixed server role, and the db_owner and db_ddladmin fixed database roles, and the object owner.
Derrick Leggett
Mean Old DBA
When life gives you a lemon, fire the DBA.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply