tablespace access

nittal · #1 (**permalink**) 01-28-09, 06:53

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???

rahul_s80 · #2 (**permalink**) 01-28-09, 08:42

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

Marcus_A · #3 (**permalink**) 01-28-09, 09:40

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."

Internet Services

Web Development

Digital Marketing

Consumer Tech