Teradata Forums / Teradata / Partner software applications/questions / Can we give ROLENAME in the CREATE USER quey? / Latest PostsInstantForum.NET v4.1.4Teradata Forumshttp://www.teradata.com/teradataforum/info@teradata.comSun, 07 Sep 2008 04:42:39 GMT20RE: Can we give ROLENAME in the CREATE USER quey?http://www.teradata.com/teradataforum/Topic9402-12-1.aspxflair123,I am sorry, but I have never seen a reserved word "ROLEBACK" before! Is it a new reserved word?Following I have inserted a CREATE USER structure that may help you:CREATE USER "Jones" FROM "td2idm"AS PERM = 1000000 BYTES, SPOOL = 1000000 BYTESPASSWORD = Jan123456FALLBACKNO BEFORE JOURNALNO AFTER JOURNALPROFILE=NULLDEFAULT ROLE=NULLCheers!Thu, 01 Nov 2007 17:05:57 GMTFabioCan we give ROLENAME in the CREATE USER quey?http://www.teradata.com/teradataforum/Topic9402-12-1.aspxHi all,Can we give ROLENAME in the CREATE USER quey?I got sample query:[color=11][size=6]"CREATE USER Jones FROM td2idm AS PERMANENT = 1000000 BYTES, SPOOL = 1000000 BYTES PASSWORD = Jan123456, ROLEBACK= ALL, FALLBACK;"[/size][/color]But this query gives me an error as:[color=11][size=6]"com.ncr.teradata.jdbc_4.util.JDBCException: [NCR] [Teradata DBMS] : Syntax error, expected something like a 'JOURNAL' keyword between ',' and the word 'ROLENAME'."[/size][/color]Please reply me......thanks in adv........Wed, 24 Oct 2007 05:43:55 GMTflair123