Sudden sys.dba_extents Issue

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
BillB
Premium Member
Premium Member
Posts: 48
Joined: Tue Nov 13, 2007 6:44 pm

Sudden sys.dba_extents Issue

Post by BillB »

Hi,

Woke up today morning with jobs in abort state which happened to run perfectly till yesterday.
##E IIS-DSEE-TDOR-00172 11:16:23(001) <BMS_9999999_104> Access to sys.dba_extents is required but not available; please
see your database administrator for select privileges.
Wondering what could have gone wrong overnight that resulted in this issue.

Need your suggestions to resolve it.

Thanks
keshav0307
Premium Member
Premium Member
Posts: 783
Joined: Mon Jan 16, 2006 10:17 pm
Location: Sydney, Australia

Post by keshav0307 »

the database administrator has revoked your(the user id to connect database) access on sys.dba_extents
Post Reply