Post reply

Cannot grant permissions with a user in the db_owner role

  • July 26, 2010 at 11:35 am

    #238124

    Hi...

    We try to execute the next command:

    GRANT SELECT ON [dbo].[TableX] TO [UTest]

    Msg 297, Level 16, State 1, Procedure TRG_LOGINCHANGELOG, Line 14

    The user does not have permission to perform this action.

    We try to execute this command using a user that is member of the db_owner role of the database.

    This does not happen in the development environment

    Does anyone has had this problem before?

    In production we have: "Microsoft SQL Server 2008 (SP1) - 10.0.2531.0 (X64)"

    In development: "Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (Intel X86)"

    by the way... sorry for my english... 🙂

  • July 26, 2010 at 11:41 am

    #1198335

    You have a trigger that is not allowing you to do any modification. That trigger is TRG_LOGINCHANGELOG. Maybe you should take at the trigger and see what is the rule set up and also try to figure out who set it up. If this is a third party application/DB, then the vendors might have put it there to make sure no one alters the permission.

    -Roy

  • July 26, 2010 at 12:59 pm

    #1198401

    You're right... Sometimes we have the answer in front of our eyes and we can't see it... Let me talk with ours DBAs... Thanks a lot...

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply