InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 06:28:14 GMT20http://www.sqlservercentral.com/Forums/Topic1319788-119-1.aspxPlease don't cross post. It just wastes peoples time and fragments replies. No replies to this thread please. Direct replies to: [url]http://www.sqlservercentral.com/Forums/Topic1319084-359-1.aspx[/url]Fri, 22 Jun 2012 01:41:45 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1319788-119-1.aspxHi 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 EvaluationroleStep 3: Grant create stored Procedure to EvaluationroleGRANT EXECUTE TO EvaluationroleGRANT VIEW DEFINITION TO EvaluationroleStep 4: USE [master] GOCREATE LOGIN [dvsuser] WITH PASSWORD=N'dvsuser', DEFAULT_DATABASE=[master], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFFGOStep 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...Fri, 22 Jun 2012 01:04:14 GMTvs.satheesh