Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
iamghost
Starting Member
2 Posts |
 Posted - 2005-01-18 : 22:27:55
|
| i have a view defined on two tables. i have denied insert, update, & delete permissions on the tables directly. i am allowing inserts into the tables via a stored procedure accessed during the insert into the view. the view has an insteadofinsert trigger defined on it. when i try to insert a record through the view or directly through the stored proc as another user from one of my user defined database roles i receive Server: Msg 8104, Level 16, State 1, Procedure uspInsert_tblCustomer, Line 36 (The current user is not the database or object owner of table dbo.tblCustomer. Cannot perform SET operation. i cannot seem to use the set identity insert on inside the stored proc when logged on as a user that is not the owner of the table even the i have granted exec permissions to the public role |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2005-01-18 : 23:33:19
|
| From Books Online (the Bible, and it's free):PermissionsExecute permissions default to the sysadmin fixed server role, and the db_owner and db_ddladmin fixed database roles, and the object owner.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
|
|
|
Performing SET operations in stored procs