Results 1 to 6 of 6
  1. #1
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Unanswered: V7.2 - USAGEAUTH on a SEQUENCE

    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
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  2. #2
    Join Date
    Nov 2005
    Location
    IL
    Posts
    557
    sathyaram,

    Check out syscat.sequenceauth
    --
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows

    DB2 v9.7.0.6 os 6.1.0.0

  3. #3
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    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
    Quote Originally Posted by Cougar8000
    sathyaram,

    Check out syscat.sequenceauth
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  4. #4
    Join Date
    Dec 2005
    Posts
    18
    Grant or Revoke it again, it will not make a difference.

  5. #5
    Join Date
    Nov 2005
    Location
    IL
    Posts
    557
    Quote Originally Posted by sathyaram_s
    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
    I was hoping it would not be the case. I wonder if it is under different name on 7.2
    --
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows

    DB2 v9.7.0.6 os 6.1.0.0

  6. #6
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    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

    Quote Originally Posted by sun4u
    Grant or Revoke it again, it will not make a difference.
    Visit the new-look IDUG Website , register to gain access to the excellent content.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •