Re: grant select on columns

Rüdiger J. Schulz (r.schulz_at_berlin.de) wrote:
: hi all,

: I try to grant select on columns to a user with

: GRANT select (field1, field2) ON schema1.table1 TO user;

: but oracle dont want to give the grant.
: what's wrong?

: R.J. Schulz

According to manual (Release 7.3 SQL Reference) 'You can only specify columns when granting the INSERT, REFERENCES, or UPDATE privilege'.

Helen Received on Fri Jul 23 1999 - 09:49:25 CDT