Topic
1 reply Latest Post - ‏2013-02-04T15:52:04Z by nivanov1
SystemAdmin
SystemAdmin
17917 Posts
ACCEPTED ANSWER

Pinned topic DB2 readonly user

‏2013-02-03T11:53:24Z |
Hi
have en easy question, i dont work that much with DB2, but only use it as a database to some of IBM other software, so sorry for the very easy quesiton :-)

I simply need to create a db2 account that can only read from the database. It should have access to query the database via SQL. Can anyone help with what permissions i should set on all the tabs?
Updated on 2013-02-04T15:52:04Z at 2013-02-04T15:52:04Z by nivanov1
  • nivanov1
    nivanov1
    231 Posts
    ACCEPTED ANSWER

    Re: DB2 readonly user

    ‏2013-02-04T15:52:04Z  in response to SystemAdmin
    That would be the SELECT privilege.

    http://pic.dhe.ibm.com/infocenter/db2luw/v10r1/topic/com.ibm.db2.luw.sql.ref.doc/doc/r0000966.html