Can we give ROLENAME in the CREATE USER quey?

Third Party Software

Can we give ROLENAME in the CREATE USER quey?

Hi 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........
1 REPLY

Re: Can we give ROLENAME in the CREATE USER quey?

flair123,

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 BYTES
PASSWORD = Jan123456
FALLBACK
NO BEFORE JOURNAL
NO AFTER JOURNAL
PROFILE=NULL
DEFAULT ROLE=NULL

Cheers!