Path: news.easynews.com!easynews!cyclone.swbell.net!cyclone-sf.pbi.net!64.245.249.51!sfo2-feed1.news.algx.net!allegiance!logbridge.uoregon.edu!newsfeed.stanford.edu!postnews1.google.com!not-for-mail From: ed.prochak@alltel.com (Ed prochak) Newsgroups: comp.databases.oracle.misc Subject: Re: Protecting tables and views? Date: 4 Apr 2002 07:52:13 -0800 Organization: http://groups.google.com/ Lines: 28 Message-ID: References: <3CABA53A.2060502@videotron.ca> NNTP-Posting-Host: 198.133.100.131 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Trace: posting.google.com 1017935534 1038 127.0.0.1 (4 Apr 2002 15:52:14 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: 4 Apr 2002 15:52:14 GMT Xref: easynews comp.databases.oracle.misc:79661 X-Received-Date: Thu, 04 Apr 2002 08:50:02 MST (news.easynews.com) GII wrote in message news:<3CABA53A.2060502@videotron.ca>... > Hi, > > Are there any other strategies or ways to protect data or tables in > ORACLE besides the SQL GRANT statement? I would like to protect some > tables and views in my ORACLE account but cannot use the GRANT statement > because I don't have enough privileges, so I need another ways using > SQL. Thanks a bunch... > > Gabriel Talk to your DBA. If they are good they must have some reason for not giving you this privilege for your own tables. (I presume these are tables created in your account.) They will either give you the Privilege or do it for you. Otherwise, the only thing I can think of is security by obscurity (rename the tables and views regularly). Ed -- Edward J. Prochak --- Magic Interface, Ltd. Ofc: 440-498-3700 on the web at --- http://www.magicinterface.com email: ed.prochak@magicinterface.com