Re: grant select on columns

From: fumi <fumi_at_tpts5.seed.net.tw>
Date: 25 Jul 1999 15:56:08 GMT
Message-ID: <7nfc2o$pr$2@news.seed.net.tw>

Graham Bleach <itdcgbnospam_at_its.hants.gov.uk> wrote in message news:7n9vme$aij$1_at_news.hants.gov.uk...
> The problem may be that you do not have the privilege to grant select on
> these columns. Try doing it as the owner of the table.
>
> I suggest you include the error message and number received on future posts.
>
> I've not had a problem with column grants in the past.

Nope.
You can NOT grant the select privilege on specific columns. The way to accomplish it is to create a view which selects the specific columns, and grant select privilege on the view.

There are only INSERT, UPDATE and REFERENCES column level privileges. Received on Sun Jul 25 1999 - 10:56:08 CDT