OS: opensuse 11.2 java: openjdk 1.6.0 h2: 1.2.131 Sql statement: [code] CREATE ROLE park LOGIN ENCRYPTED PASSWORD 'md5cc67fcf394136f13be5b9615a8ff6310' NOSUPERUSER NOINHERIT CREATEDB CREATEROLE; [/code]
The error: [quote] Error: org.h2.jdbc.JdbcSQLException: Syntax error in SQL statement "CREATE ROLE PARK LOGIN[*] ENCRYPTED PASSWORD 'md5cc67fcf394136f13be5b9615a8ff6310' NOSUPERUSER NOINHERIT CREATEDB CREATEROLE "; SQL statement: CREATE ROLE park LOGIN ENCRYPTED PASSWORD 'md5cc67fcf394136f13be5b9615a8ff6310' NOSUPERUSER NOINHERIT CREATEDB CREATEROLE [42000-131], SQL State: 42000, Error Code: 42000 [/quote] Can anyone show more role creation example? If the "CREATE ROLE" has just this syntax (http://www.h2database.com/ html/grammar.html#create_role), so I can't neither assign password nor grants to the role. Is that right? I'm trying to convert a postgresql database to h2. Regards, Gilberto Caetano de Andrade www.secad.to.gov.br blog.gilbertoca.com -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
