HELP--removing PUBLIC from one user

From: Ned Hamilton <esh6n_at_brain.neuro.virginia.edu>
Date: Thu, 15 Sep 1994 19:09:34 GMT
Message-ID: <Cw6qJz.3Fo_at_murdoch.acc.Virginia.EDU>


Oracle has a dozen or so tables with PUBLIC access (e.g. public.form_blk, public.form_page, etc.) I want to block the access of these tables to one user but keep the PUBLIC access to all other users.

I don't want to have to go thru all of these tables dropping the public access and re-granting the access to all but this user.

Any suggestions?

(Why am I doing this? Because PowerBuilder displays all of these tables when a data window is created and it's getting to be a pain when I am building a lot of new data windows.)

=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=

  Ned Hamilton	                 NTC       Department of Neurosurgery
  nedh_at_virginia.edu                          University of Virginia

=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=
Received on Thu Sep 15 1994 - 21:09:34 CEST

Original text of this message