Hi,

I have db2 instance created as an administrator on db2 udb 9.5 on windows 2008.

There is no SYSADM_GROUP defined. I want to create a user with only select access on the database and does not have any other authority and privileges except for connect.

I tried the below:
revoke the createtab,binda dd,connect,impl icit_schema etc from public.
create a group and add it to SYSADM_GROUP...