You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-user@db.apache.org by damon leong <lo...@yahoo.com> on 2006/09/25 04:16:45 UTC
CREATE SCHEMA schema name AUTHORIZATION username
can derby use the
CREATE SCHEMA schema name AUTHORIZATION username ?
because when i run ij the error say
ERROR 42X01: Syntax error: Encountered "AUTHORIZATION" at line 5, column 22.
---------------------------------
How low will we go? Check out Yahoo! Messengers low PC-to-Phone call rates.
Re: CREATE SCHEMA schema name AUTHORIZATION username
Posted by Anders Morken <an...@stud.ntnu.no>.
damon leong:
> actually i want restrict some user to select some data
> using schema but grant and revoke cannot in 10.1.3
> is that any way to set authorization user ?
Well, as I mentioned earlier, SQL Authorization is a new feature in
Derby 10.2. If you feel like helping us get 10.2 ready for release, feel
free to test the latest release candidate build - see more info about
10.2.1.5 at the following URL:
http://www.mail-archive.com/derby-dev@db.apache.org/msg30579.html
This is probably pretty close to the final release, but it's not an
official release yet. =)
--
Anders Morken
My opinions may have changed, but not the fact that I am right!
Re: CREATE SCHEMA schema name AUTHORIZATION username
Posted by damon leong <lo...@yahoo.com>.
actually i want restrict some user to select some data
using schema but grant and revoke cannot in 10.1.3
is that any way to set authorization user ?
Anders Morken wrote:
>
> damon leong:
>> beside this method is that any way
>> do the same thing ?
>
> I'm not quite sure what you're trying to achieve?
>
> If you want to create a schema, just don't include the "AUTHORIZATION"
> part, i.e. like this:
>
> ij> CREATE SCHEMA foo;
> 0 rows inserted/updated/deleted
>
> --
> Anders Morken
>
> My opinions may have changed, but not the fact that I am right!
>
>
--
View this message in context: http://www.nabble.com/Re%3A-CREATE-SCHEMA-schema-name-AUTHORIZATION-username-tf2330254.html#a6482991
Sent from the Apache Derby Users mailing list archive at Nabble.com.
Re: CREATE SCHEMA schema name AUTHORIZATION username
Posted by Anders Morken <an...@stud.ntnu.no>.
damon leong:
> beside this method is that any way
> do the same thing ?
I'm not quite sure what you're trying to achieve?
If you want to create a schema, just don't include the "AUTHORIZATION"
part, i.e. like this:
ij> CREATE SCHEMA foo;
0 rows inserted/updated/deleted
--
Anders Morken
My opinions may have changed, but not the fact that I am right!
Re: CREATE SCHEMA schema name AUTHORIZATION username
Posted by damon leong <lo...@yahoo.com>.
thank you for reply
beside this method is that any way
do the same thing ?
Anders Morken wrote:
>
> damon leong:
>> can derby use the
>> CREATE SCHEMA schema name AUTHORIZATION username ?
>>
>> because when i run ij the error say
>> ERROR 42X01: Syntax error: Encountered "AUTHORIZATION" at line 5,
>> column
>> 22.
>
> I'd guess you're trying to use a feature which is new in 10.2 (SQL
> Authorization) on an older version of Derby. Which version are you
> using, and have you made sure that you're referring to the documentation
> for that version, and not the latest 10.2 docs?
>
> --
> Anders Morken
>
> My opinions may have changed, but not the fact that I am right!
>
>
--
View this message in context: http://www.nabble.com/Re%3A-CREATE-SCHEMA-schema-name-AUTHORIZATION-username-tf2330254.html#a6482666
Sent from the Apache Derby Users mailing list archive at Nabble.com.
Re: CREATE SCHEMA schema name AUTHORIZATION username
Posted by Anders Morken <an...@stud.ntnu.no>.
damon leong:
> can derby use the
> CREATE SCHEMA schema name AUTHORIZATION username ?
>
> because when i run ij the error say
> ERROR 42X01: Syntax error: Encountered "AUTHORIZATION" at line 5, column
> 22.
I'd guess you're trying to use a feature which is new in 10.2 (SQL
Authorization) on an older version of Derby. Which version are you
using, and have you made sure that you're referring to the documentation
for that version, and not the latest 10.2 docs?
--
Anders Morken
My opinions may have changed, but not the fact that I am right!