Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2008
    Posts
    131

    Question Unanswered: tablespace access

    Hi,
    I am using db2v9.5 ESE on windows
    I am not able to view any of the tablespace objects. trying to access it throws the error:
    SQL1092N " " does not have the authority to perform the requested command.

    All other objects can be viewed and accessed. how is it possible to view other objects then when it says i don't have authority to view tablespaces???

  2. #2
    Join Date
    Jul 2006
    Location
    Pune , India
    Posts
    433
    where are you facing the problem. contol centre ?

    May be you might be having select priv on some tables on that tablespace but not a USE on tablespace
    Rahul Singh
    Certified DB2 9 DBA / Application Developer

  3. #3
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Quote Originally Posted by nittal
    Hi,
    I am using db2v9.5 ESE on windows
    I am not able to view any of the tablespace objects. trying to access it throws the error:
    SQL1092N " " does not have the authority to perform the requested command.

    All other objects can be viewed and accessed. how is it possible to view other objects then when it says i don't have authority to view tablespaces???
    Please explain exactly what you mean by "view" and "access."
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

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