Could someone confirm this bug?
or give any suggestion?
Thx,
Marcin

U�ytkownik "Marcin P" <[EMAIL PROTECTED]> napisa� w wiadomo�ci
news:[EMAIL PROTECTED]
> 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

Reply via email to