View previous topic :: View next topic
|
Author |
Message |
senthilssg
New User
Joined: 09 Dec 2005 Posts: 64 Location: USA
|
|
|
|
Hi All,
GRANT USE OF TABLESPACE dbname.tablespace TO userid;
After the execution of this statement , this information is stored in which catalog table? I am not able to find entry for this in catalog tables.
Could you please clear my doubt and kindly let me know which catalog table has entry for these privileges
Regards,
Senthil |
|
Back to top |
|
|
anamikak
New User
Joined: 10 May 2006 Posts: 64 Location: Singapore
|
|
|
|
try qurerying SYSIBM.SYSUSERAUTH table . |
|
Back to top |
|
|
senthilssg
New User
Joined: 09 Dec 2005 Posts: 64 Location: USA
|
|
|
|
Hi all ,
I have got that answer for my doubt . These information (GRANT USE OF TABLESPACE /BUFFERPPOL/STOGROUP etc ) are aviable in the SYSIBM.SYSRESAUTH table .
Regards
Senthil |
|
Back to top |
|
|
|