Hi all. I hope i will be a little more understandable now. This is my situation. If i apply the command "get dbm cfg" i receive the result: ............................................................................ .... ............................................................................ .... SYSADM group name (SYSADM_GROUP) = DBA SYSCTRL group name (SYSCTRL_GROUP) = DBA SYSMAINT group name (SYSMAINT_GROUP) = DBA ............................................................................ .... ............................................................................ ....
Where DBA is the local group which the user DB2ADMIN belongs to. But if i apply the command "get authorizations" for any db of the dbm, i obtain for the user DB2ADMIN: Direct SYSADM authority = NO Direct SYSCTRL authority = NO Direct SYSMAINT authority = NO Direct DBADM authority = YES Direct CREATETAB authority = YES Direct BINDADD authority = YES Direct CONNECT authority = YES Direct CREATE_NOT_FENC authority = YES Direct IMPLICIT_SCHEMA authority = YES Direct LOAD authority = YES Indirect SYSADM authority = NO Indirect SYSCTRL authority = NO Indirect SYSMAINT authority = NO Indirect DBADM authority = NO Indirect CREATETAB authority = YES Indirect BINDADD authority = YES Indirect CONNECT authority = YES Indirect CREATE_NOT_FENC authority = NO Indirect IMPLICIT_SCHEMA authority = YES Indirect LOAD authority = NO I think i should i read "Indirect SYSADM authority = YSE Indirect SYSCTRL authority = YSE Indirect SYSMAINT authority = YES" didn't I???? Can anyone help me? Thank you so much. > -----Messaggio originale----- > Da: Borgoglio, Francesco > Inviato: Friday, March 14, 2003 10:10 AM > A: 'DB2 Mainframe List'; 'DB2 Open System List' > Oggetto: The right grant to get snapshot > > Hi all, > i'm trying to apply the command "get snapshot for all on mydb", > (on a WINNT 4.0 platform, DB2 UDB 7.2), > and i receive the following error: > SQL1092N "DB2ADMIN" does not have the authority to perform the requested > command. > I granted the sysadm, sysctrl and sysmaint to the group which DB2ADMIN > belong to, > but nothing improves. > What kind of privilege do i have to grant to? > > Thank you so much. > > > > True ignorance is not the absence of knowledge, > but the refusal to acquire it. > > - ::: When replying to the list, please use 'Reply-All' and make sure ::: a copy goes to the list ([EMAIL PROTECTED]). *** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] *** For more information, check http://www.db2eug.uni.cc
