Hi, It seems to me, that granting privilege SELUPD on tables doesn't work properly. I was logged in as user TEST and created a simple Table. Then granted SELUPD privilege on this table to user TEST2 with following statement: GRANT SELUPD ON "TEST"."MY_TABLE" TO TEST2 And whenever I log as TEST2 and try the statement: SELECT * FROM "TEST"."MY_TABLE" it returns "Missing privilege: SELECT". Trying UPDATE "TEST"."MY_TABLE" SET COL_NAME='Name' completes successfully. So it seems to me that because of a bug a privilege SELUPD=UPDATE and not SELUPD = SELECT + UPDATE (as it is stated in documentation). Granting privileges with: GRANT SELECT,UPDATE ON "TEST"."MY_TABLE" TO TEST2 works fine. I use version 7.3.29 .
Could someone give me any hint? Best regards, Marcin Pytel Talex S.A. _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
