DB2 V7.2 on Unix

How do you identify whether USAGE has been granted to PUBLIC on a sequence ?

I don't seem to remember how it used to be and searches haven't helped much (yet!)

Thanks
Sathyaram

sathyaram,

Check out syscat.sequenceauth

Thanks

Doesn't exist on 7.2 .. IIRC, the view was introduced in V8 only

/home/myuserid>db2 "select * from syscat.sequenceauth"
SQL0204N "SYSCAT.SEQUENCEAUTH" is an undefined name. SQLSTATE=42704

Grant or Revoke it again, it will not make a difference.

I was hoping it would not be the case. I wonder if it is under different name on 7.2

Grant/Revoke is not the problem ..

At a customer site, i'm developing a SQL script to consolidate and present the current authorizations on the database ... Obvioulsy, it should be possible to run anytime later .. I hate tell - 'In V7, if a normal user is able to use a SEQUENCE, permissions are granted to PUBLIC' ..

Thanks

Sathyaram