Post reply

Table permission denied

  • January 28, 2014 at 7:43 am

    #303829

    Hi all,

    I have given the full access(db_owner) to user for the test database. Users are able to work on Stored procedure but when they try to add or modify any column on the table they are getting following error:

    "Table is set to read only,user does not have enough rights on this table"

    Can anyone please help me on this.

    Thanks...

  • January 28, 2014 at 7:55 am

    #1683930

    is there a DDL trigger on the database that is designed to protect specific tables?

    that sounds like a custom error message to me.

    select * from sys.server_triggers

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

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

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