|
|
|
Forum Newbie
Group: Forum Members
Last Login: 10/24/2007 7:04:33 AM
Posts: 3,
Visits: 3
|
|
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........
|
|
|
|
|
Forum Member
Group: Forum Members
Last Login: 5/29/2008 1:27:36 PM
Posts: 43,
Visits: 48
|
|
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!
|
|
|
|