Results 1 to 5 of 5
  1. #1
    Join Date
    Feb 2002
    Location
    Hamilton
    Posts
    150

    Unanswered: assigning read only rights

    I was hoping that someone could show me how to assing read only rights to DB2 tables? If this can be done at a group level(we have that set up) or if it has to be done on a individual by individual user basis.

    We are running DB2 EEE 7.2 on AIX 4.3.3

    thanks in advance

    Mark

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: assigning read only rights

    Reoke the exisiting privelages held by the users and groups.

    REVOKE SELECT,INSERT,UPDATE,DELETE,CONTROL on <tabname> from <user/group>

    Then issue a
    GRANT SELECT ON <tabname> TO <user/group>

    Read the chapter on 'Controlling Database Access' in Admin Guide for detailed information.




    Originally posted by mark_maz
    I was hoping that someone could show me how to assing read only rights to DB2 tables? If this can be done at a group level(we have that set up) or if it has to be done on a individual by individual user basis.

    We are running DB2 EEE 7.2 on AIX 4.3.3

    thanks in advance

    Mark

  3. #3
    Join Date
    Feb 2002
    Location
    Hamilton
    Posts
    150
    So it has to be done on a table per table basis?? or can it be done on the whole database?


    btw, thank you for your help

    Mark

  4. #4
    Join Date
    Feb 2002
    Location
    Hamilton
    Posts
    150
    I have successfully granted connect to the group that requires it, now i am finding out that I need to grant select on the schema.tableame. My question this time is can it be done on the entire schema? ie the access is needed to do the same schema for the group, ex root.tablename where root is the schema that everyone needs to access.

    thanks in advance

    mark

  5. #5
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    You'll have to give permissions to tables indivudally ...

    Originally posted by mark_maz
    I have successfully granted connect to the group that requires it, now i am finding out that I need to grant select on the schema.tableame. My question this time is can it be done on the entire schema? ie the access is needed to do the same schema for the group, ex root.tablename where root is the schema that everyone needs to access.

    thanks in advance

    mark

Posting Permissions

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