read/write/execute to pl/sql grants For a current task and future references, I am wondering how pl/sql grants (select, insert, update, delete, references, alter, index, all) are categorized from a read/write/execute or read/read-write/read-write-execute point of view? A lot of end users or non-dba folks tend to use the later language when asking for access or grant privileges where I work. Any feedback is appreciated :)
Read: READ. 

Not SELECT. Forget SELECT. SELECT privilege allows users to run SELECT .. FOR UPDATE, which modifies the metadata in the database blocks (not the user data) and locks the affected rows.

READ privilege is available starting with 12c.

Write: INSERT, UPDATE, DELETE.

Execute: EXECUTE

For the rest (Object Privileges), most people do not even know about them and can happily live without them.