he granted sysadm access to stgcrm accountI don't know what does it mean exactly, I'm not a DB2 ghuy though. However, every application has its own specifications on database level, and SYSADM's account is a special account. You can certainly revoke DBA access, that's more or less it.
ranjitkumar wrote:I'm afraid, SYSADM is not a role and privilege neither that you can "remove". Again, I assume it is DBA which can be revoked. I do not know what covers DATAACCESS in DB2, but the user must be able to create/drop table/view/index.
yes STGCRM is my access id. My dba says he want to remove DBADM access( sysadm in oracle) and will provide DATAACCESS at database level. i am not sure will this cause any issues?