[prev in list] [next in list] [prev in thread] [next in thread] 

List:       hsql-user
Subject:    Re: [hsql-user] How to: CREATE TABLE scott.customer (...)
From:       Alex Boisvert <boisvert () exoffice ! com>
Date:       2000-05-18 16:03:10
[Download RAW message or body]

Lennart Petersson wrote:
> 
> Is this not supposed to work? Any other way to create a table for a
> specific user?
> 

Hi Lennart,

A table name cannot contain a dot (".").  You should name your table
something like "scott_customer".  Such as:

create table scott_customer (name char(40) not null, address varchar,
...);

And if you want table "scott_customer" to be only accessible to user
"scott", you can do the following:

create user "scott" password "xxxxxx";
grant all on scott_customer to "scott";

This way, only Scott (and the system administrator) will have access to
this table.

regards,
alex

-- 
Alex Boisvert, XJ2EE Project Manager
Exoffice Technologies, Inc.  
http://www.exoffice.com
mailto:boisvert@exoffice.com

[prev in list] [next in list] [prev in thread] [next in thread]