another role question
From: Jason Yi <jason_at_woody.uucp>
Date: 24 Sep 1993 01:27:09 GMT
Message-ID: <27tidd$hen_at_elroy.jpl.nasa.gov>
COLUMN1 NUMBER <== primary key
COLUMN2 NUMBER
COLUMN3 NUMBER
COLUMN4 NUMBER CREATE ROLE SW; GRANT SELECT ON SYSTEM.MYTABLE TO SW;
GRANT DELETE, INSERT, UPDATE
(COLUMN2, COLUMN3, COLUMN4)
ON SYSTEM.MYTABLE
TO SW;
Date: 24 Sep 1993 01:27:09 GMT
Message-ID: <27tidd$hen_at_elroy.jpl.nasa.gov>
Hi,
As I've been experimenting with roles, I'm getting more confused.
In below example,
MYTABLE
COLUMN1 NUMBER <== primary key
COLUMN2 NUMBER
COLUMN3 NUMBER
COLUMN4 NUMBER CREATE ROLE SW; GRANT SELECT ON SYSTEM.MYTABLE TO SW;
GRANT DELETE, INSERT, UPDATE
(COLUMN2, COLUMN3, COLUMN4)
ON SYSTEM.MYTABLE
TO SW;
GRANT SW TO OPS$MYSELF; Does above grant statement allows me to select, delete, insert, and update to individual columns except COLUMN1? If not, what does above grants mean and exactly what sort of privilege OPS$MYSELF have over table MYTABLE?
Thanks
jason_at_jpl.woody.nasa.gov Received on Fri Sep 24 1993 - 03:27:09 CEST