RE: Column level grants - THANKS

From: Andrey Bronfin <andreyb_at_elrontelesoft.com>
Date: Wed, 24 Apr 2002 07:23:42 -0800
Message-ID: <F001.0044DE04.20020424072342@fatcity.com>

thanks a lot to all who replied !

DBAndrey

• 03-9254520
• 058-548133
• mailto:andreyb_at_elrontelesoft.com

-----Original Message-----
Sent: Wed, April 24, 2002 4:24 PM
To: Multiple recipients of list ORACLE-L

I deleted the original mail, but You can find this topic in

Oracle8i SQL Reference
Release 3 (8.1.7)
Part Number A85397-01

SQL statement GRANT
look under section syntax
grant_object_privileges_clause image

Although there is a note
column
Specify the table or view column on which privileges are to be granted. You can specify columns only when granting the INSERT, REFERENCES, or UPDATE privilege. If you do not list columns, the grantee has the specified privilege on all columns in the table or view.

Gints Plivna
IT Sistēmas, Merķeļa 13, LV1050 Rīga
http://www.itsystems.lv/gints/

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
  INET: G.Plivna_at_itsystems.lv

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Andrey Bronfin
  INET: andreyb_at_elrontelesoft.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Wed Apr 24 2002 - 10:23:42 CDT