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.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 getting error at the time of Insertion

Author  Topic 

shubhada
Posting Yak Master

117 Posts

Posted - 2005-12-13 : 07:14:50
Hi,
I am trying to insert the data in a table through application .
bur getting the following error.
error : only owner of object 'LookCPatTyp' or a user with SA role can run this command.

please tell me how to overcom from this problem.

shubhada

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2005-12-13 : 08:19:01
The user doesnt have permissions. Make sure the use has Insert permission

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page

activecrypt
Posting Yak Master

165 Posts

Posted - 2005-12-14 : 07:41:54
Hi,
grant insert permission to user or make him/her to member of datawriter and datareader role , refer BOL for more.

:-)
Regards

Andy Davis
Activecrypt Team
--------------------------------------------
SQL Server Encryption Software
http://www.activecrypt.com
Go to Top of Page
   

- Advertisement -