satyender
New User
Joined: 05 Jan 2008 Posts: 50 Location: Olympia, WA, USA
|
|
|
|
Hi all,
How to grant create table privileges to a particular user.
I am trying in the following way,Please correct me.
GRANT CREATETAB ON DBLCST5 TO T0J0AJ7;
Error:
---------+---------+---------+---------+---------+---------+---------+-----
SET CURRENT SQLID='LCSADM';
---------+---------+---------+---------+---------+---------+---------+-----
DSNE616I STATEMENT EXECUTION WAS SUCCESSFUL, SQLCODE IS 0
---------+---------+---------+---------+---------+---------+---------+-----
GRANT CREATETAB ON DBLCST5 TO T0J0AJ7;
---------+---------+---------+---------+---------+---------+---------+-----
DSNT408I SQLCODE = -557, ERROR: INCONSISTENT GRANT/REVOKE KEYWORD (IMPLIED
TABLE). PERMITTED KEYWORDS ARE DATABASE
DSNT418I SQLSTATE = 42852 SQLSTATE RETURN CODE
DSNT415I SQLERRP = DSNHSM3A SQL PROCEDURE DETECTING ERROR
DSNT416I SQLERRD = 2801 0 0 -1 1 0 SQL DIAGNOSTIC INFORMATION
DSNT416I SQLERRD = X'00000AF1' X'00000000' X'00000000' X'FFFFFFFF'
X'00000001' X'00000000' SQL DIAGNOSTIC INFORMATION
---------+---------+---------+---------+---------+---------+---------+-----
DSNE618I ROLLBACK PERFORMED, SQLCODE IS 0
DSNE616I STATEMENT EXECUTION WAS SUCCESSFUL, SQLCODE IS 0 |
|