Marcin Pytel wrote :
>I've found a strange problem with getting current values from
>serial column of table.
>As it is possible from version 7.3.0.29 I decided to give it a trial.
>And I think, there must be a little bug with using it
>when currently logged user is not the owner of the table.
>Below is my example - You can reproduce this with an empty
>instance of database - version 7.3.0.29
>//Logged as DBA
>CREATE USER UZYT_TEST PASSWORD XXX DBA NOT EXCLUSIVE
>//Logged as UZYT_TEST
>CREATE USERGROUP T_USERS RESOURCE TIMEOUT 10000 NOT EXCLUSIVE
>//
>CREATE USER JOHN PASSWORD XXX USERGROUP T_USERS
>//
>CREATE TABLE "TBL_TEST"
>(
> "REC_ID" Fixed (20) NOT NULL DEFAULT SERIAL,
> "NAME" Varchar(20),
> PRIMARY KEY ("REC_ID")
>)
>//
>GRANT ALL ON "TBL_TEST" TO T_USERS
This is a bug. The current implementation requires the owner privilege
for the table to be able to inquire the currval value.
I will correct this very soon.
Unfortunately I don't see any workaround for the problem.
Thomas
--
Thomas Anhaus
SAP DB, SAP Labs Berlin
[EMAIL PROTECTED]
http://www.sapdb.org/
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
