Hey Ian!!

Thanks a lot for reminding DB2_SNAPSHOT_NOAUTH ......i did used it
earlier, infact it was me who had set up that variable long time back
in the same server i mention in my post.

People say u forget things when u fall in love


Ian wrote:
> Dibur wrote:
> > Hi,
> >
> > The way authorities are granted in DB2 are very vague.In one of our
> > production systems the users under staff group in AIX have sysmon
> > authorities and i have checked dbm cfg and there sysmon_group is empty.
> > So how every member of staff have sysmon authority.why so?
> >
> > How can a user run "db2 list applications" and db2 "get snapshot ....."
> > with these authorities?
>
> Is SYSADM_GROUP set to STAFF?
>
> Is the DB2_SNAPSHOT_NOAUTH registry variable set?