MVSFORUMS.com

[shekar123]

Hai,

I am trying to create a table in a particular database pertaining to a tablespace but i am getting SQL error -551 saying
"USERID DOES NOT HAVE THE PRIVILEGE TO PERFORM OPERATION CREATE TABLE ON OBJECT databasename".

My query is

Create userid.tablename
(empno char(6) not null,
ename varchar(15) not null)
in databasename.tablespacename

I know the reason as i might not have the authority to create table in that particular database ? Is there any way by means by which i can know the default values for the DB2 database name and tablespace and stogroup assigned to my userid so that i can give the details correctly in my query and solves my problem ?

[kolusu]