SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 permission of user in sql
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

amirs
Constraint Violating Yak Guru

India
259 Posts

Posted - 05/27/2013 :  23:16:01  Show Profile  Reply with Quote
Dear Members

If one of my table i have write a trigger to insert records.i have insert records in sql query this is work fine. but i have insert a record in use application i got a following error in event viewer.this application connect a different sql username.i have done all the permission of user.

Event Type: Error
Event Source: Application Name
Event Category: Msql7_srv
Event ID: 1000
Date: 5/28/2013
Time: 8:17:29 AM
User: computername\username
Computer: computername
Description:
Env (d:\app-path)
Keyword MSQL Messages
Username username type S language 2
Process 0x1fe4
Lasterror 0
Errno 0
bdberrno 0
Message
dbs_errno = 1297 Error 1297 occurred:
Error sqlcode 297 (sqlstate: 42000, Return code: -1, diagRecNum: 1) during SQLExecute.
[Microsoft][ODBC SQL Server Driver][SQL Server]The user does not have permission to perform this action.
Flushed at \db\servers\MSQL\msql_error.c : #504.

any one can help me what is error.
where i can permission of user

bandi
Flowing Fount of Yak Knowledge

India
2168 Posts

Posted - 05/28/2013 :  00:02:42  Show Profile  Reply with Quote
refer this link http://social.msdn.microsoft.com/Forums/en-US/sqldataaccess/thread/e52fd13f-8b5f-4bb5-bc44-bda50b4d626e
I think you need to have the EXECUTE AS permission for that TRIGGER

--
Chandu
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.03 seconds. Powered By: Snitz Forums 2000