Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Trigger Not Executing Expand / Collapse
Author
Message
Posted Friday, June 22, 2012 1:04 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: 2 days ago @ 6:20 AM
Points: 61, Visits: 368
Hi

In My Organization we are planned to imlement a role based security.I created a one role . Role name is called "Developer".Under this role i created two users.I use follwing Statement.
Step 1 : Create the Role
CREATE ROLE [Evaluationrole]
Step 2:
GRANT insert to Evaluationrole
GRANT update to Evaluationrole
GRANT delete to Evaluationrole

Step 3:

Grant create stored Procedure to Evaluationrole
GRANT EXECUTE TO Evaluationrole
GRANT VIEW DEFINITION TO Evaluationrole

Step 4:

USE [master]
GO
CREATE LOGIN [dvsuser] WITH PASSWORD=N'dvsuser', DEFAULT_DATABASE=[master], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF
GO

Step 5 :
CREATE USER [dvsuser] FOR LOGIN [dvsuser]

EXEC sp_addrolemember N'Evaluationrole', N'dvsuser'



Here in this user Create stored Procedure and execute the stored procedure every thisk working file. but I am facing Problem in Trigger. For Example Any table I am having "Delete" trigger means, that time that table records not allow to delete the records. I am facing follwing Error

The user does not have permission to perform this action.


Please Give me a solution . I want this user execute the trigger also.


Thank You...
Post #1319788
Posted Friday, June 22, 2012 1:41 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Yesterday @ 3:30 PM
Points: 41,531, Visits: 34,448
Please don't cross post. It just wastes peoples time and fragments replies.

No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic1319084-359-1.aspx



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1319797
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse