Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2003
    Posts
    6

    Question Unanswered: Set database to read-only

    Please can someone advise me how to set my Informix database to read only?

  2. #2
    Join Date
    Aug 2003
    Location
    Argentina
    Posts
    780

    Re: Set database to read-only

    Originally posted by jxh
    Please can someone advise me how to set my Informix database to read only?
    Hi,

    Is not possible to setear it to read only you can execute "database xxxxx exclusive" or clear all the permissions of connect, resource, dba and rolles.

    Gustavo.

  3. #3
    Join Date
    Aug 2003
    Posts
    68
    To set the database to "read only" you have to revoke all permissions on every table to all users. Then you have to grant select permissions on all tables to all users.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •