Hi again!
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
//Logged as UZYT_TEST - works perfectly
//Logged as JOHN - the second line causes error 4020 - Unknown sequence name
TBL_TEST
INSERT INTO "UZYT_TEST"."TBL_TEST" (NAME) VALUES('Anna')
//
SELECT "UZYT_TEST"."TBL_TEST".CURRVAL FROM DUAL
Could give me a workaround?? Any ideas?
Best regards,
Marcin Pytel
Talex S.A. Pozna�
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
