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
"CRE
: GRANT ALL ON SCHEMA park TO park
[ERROR] org.h2.jdbc.JdbcSQLException: Table "SCHEMA" not found; SQL
statement:
GRANT ALL ON SCHEMA park TO park [42102-131]
[INFO] 1 of 3 SQL statements executed successfully
[INFO] [compiler:compile {execution: default-compile}]
[/code]
Thanks,
Gilberto
Hi, Thomas!
Sorry for delay, I've to disable email notification because this group
has high traffic. :)
On May 11, 4:31 pm, Thomas Mueller
wrote:
> Hi,
>
> > If the "CREATE ROLE" has just this syntax (http://www.h2database.com/
> > html/grammar.html#create_role), so I can't neither assign passwor
At the end of this post[1] you will find the script to extract object
definition and their grants.
Regards,
Gilberto
[1]http://blog.gilbertoca.com/?p=338
On 20 jun, 17:30, Thomas Mueller wrote:
> Hi,
>
> Do you have a SQL script to create the Oracle database? If yes you
> could use that (it's pr
I usually use this one: http://www.sqlpower.ca/page/architect .
This feature(Data Model Comparison) is the better one:
http://www.sqlpower.ca/page/architect?slide=11
Regards,
Gilberto
On 30 jun, 11:21, Arni Arent wrote:
> Hi
>
> I am making an application which will use an in-memory database, a