July 11, 2002 at 6:30 pm
I found that some of the tables in my database is read-only. Does anyone know how I can change them to be not.
July 11, 2002 at 8:30 pm
Check the triggers.
Not sure you can mark a table read only. I think you can a filegroup. Or a database
Steve Jones
July 12, 2002 at 5:36 am
Steve is right, this can only be if the tables are in a DB or Ilegroup marked read only or triggers are in place to prevent changes.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
July 15, 2002 at 5:22 pm
I double check with couple levels of security associated with the read-only tables.
-- The primary file group the database in is not read-only;
-- the Access option of the database is not read-only,
-- there is no trigger associated with the table.
-- the permission in the database or the tables are all not marked (natural).
I don't know in the same database why there are still tables read-only, some are editable, if you don't think we can independently mark a table read-only.
Any more idea?
July 15, 2002 at 6:38 pm
Possibly the login is just a member of the datareader role and nothing else?
Andy
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply