AIX 5.3 - DB2 9.7FP3a

I'm logged in as isurvdb2

If I look in smitty, it says my primary group is gsurvdb2.

If I look at the SYSADM_GROUP dbm parameter, it says GSURVDB2.

Shouldn't I have read to all tables? I've logged out and back in.
I've stopped/restarted the instance.

Thanks.

On Mar 15, 8:19*am, Richard <rmcgor... (AT) gmail (DOT) com> wrote:
No, in DB2 9.7, IBM added the concept of separation of duties,
and added several new privileges, including DATAACCESS.

For databases that were created using 9.7, users with SYSADM
authority do not automatically get DATAACCESS privilege**. A user
with SECADM authority must grant DATAACCESS.

You can read about these changes here:

http://publib.boulder.ibm.com/infoce.../c0054241.html


** For databases upgraded from DB2 9.5 or earlier to 9.7, SYSADM
users will automatically be granted DATAACCESS and ACCESSCTRL,
so the upgrade won't break applications.

On Mar 15, 12:41*pm, Ian <ianb... (AT) mobileaudio (DOT) com> wrote:


Thanks. This database was upgraded to 9.7, so you'd think I'd have
the
required access, but since the instance owner account was not properly
assigned to the SYSADM_GROUP when we upgraded, it might explain why
I'm seeing the issue.