Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Save Password
Forgot your Password?

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

Constraint Violating Yak Guru

260 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
Env (d:\app-path)
Keyword MSQL Messages
Username username type S language 2
Process 0x1fe4
Lasterror 0
Errno 0
bdberrno 0
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

Flowing Fount of Yak Knowledge

2242 Posts

Posted - 05/28/2013 :  00:02:42  Show Profile  Reply with Quote
refer this link
I think you need to have the EXECUTE AS permission for that TRIGGER

Go to Top of Page
  Previous Topic Topic Next 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