Make read only database???
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Make read only database???

  1. #1
    Join Date
    Mar 2001
    Posts
    54
    Hi All,

    We are running a database ( 7.3.4).We have to disable users (100 users)dml operation on the database,But they can query the database.Is there any short way to make it .


    Kindly Advice Me
    Thanx
    JC

  2. #2
    Join Date
    Mar 2001
    Location
    Ireland/Dublin
    Posts
    684
    I do not know exactly about 7.3 version, may be you can try:
    ALTER DATABASE OPEN READ ONLY;
    or
    ALTER TABLESPACE accounting READ ONLY;
    Best wishes!
    Dmitri

  3. #3
    Join Date
    Aug 2001
    Location
    chennai,bangalore
    Posts
    840
    Try to read on the "PRODUCT_USER_PROFILE" table.This table is updatable.This table is read each time a user starts a session and all the privileges listed in this table will be granted to the user.So just updated this table for all the users with only select privilages.This is a little tedious process but is very effective.

    regards
    anandkl
    anandkl

Posting Permissions

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



Click Here to Expand Forum to Full Width